InfoPath Dev

All,

I've a field with a single small value which can be up to 2 decimal places i.e. 5.50

I've another field (total ) with  a much lager value i.e. 147. Can InfoPath do the equivalent of an excel MOD function. i.e. =IF(MOD(A1,B1)=0,"yes","no") ?

 A1 being my larger number, B1 being my smaller number.

I'm not always going to know the smaller number so a quick math formula  on the form would help.

Thanks

W 

 This can be done.

You'll need some helper fields (naturally)

Fields, LargeNumber, SmallNumber,Mod,Result

Mod has the following default value  LargeNumber mod SmallNumber

I added 2 rule to the smaller number field

1. Condition: if mod = 0 set result field to yes.

2. Condition: if mod NOT equal  0 set result field to no