Get Maximum Value Field

[erugalatha]

Hi,

I have 4 fields on an InfoPath form (e.g. FieldA, FieldB, FieldC and
FieldD).
I wish to add FieldA + FieldB and then FieldA + FieldC and whichever
result is the highest value then I want to put that value into FieldD.

How can I do this?

Thanks for your help.

 

[S.Y.M. Wong-A-Ton]

First you need to decide on a trigger for the calculation. This could be when
the value of the fields change or when a button is clicked. Once you have
this you can add 2 rules on FieldA, FieldB, and FieldC if you decided to
trigger the calculation whenever the value of the fields change, or on the
button if you decided to trigger the calculation whenever a button is
clicked.

Add a first rule with an action "Set a field's value", select "FieldD" as
the field to set, and enter "FieldA+FieldB" as its value. Then add the
following "Condition" to this rule: FieldB is greater than FieldC.

Add a second rule with an action "Set a field's value", select "FieldD" as
the field to set, and enter "FieldA+FieldC" as its value. Then add the
following "Condition" to this rule: FieldC is greater than FieldB.

The only thing left is for you have to decide what to do when FieldA+FieldB
is equal to FieldA+FieldC, since this is not caught by the 2 conditions
specified above.

 

[erugalatha]

Hi,

Thanks for your help.

I ended up using the max() function in FieldD.
e.g. max(FieldB | FieldC) + FieldA