Get Maximum Value Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

erugalatha@gmail.com - 31 Jul 2006 15:11 GMT

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.

Reply to this Message

S.Y.M. Wong-A-Ton - 31 Jul 2006 21:16 GMT

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.
---
S.Y.M. Wong-A-Ton

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks for your help.

Reply to this Message

erugalatha@gmail.com - 01 Aug 2006 11:59 GMT

Hi,

Thanks for your help.

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

> 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
[quoted text clipped - 27 lines]
> >
> > Thanks for your help.

Reply to this Message