Newbie Questions

Re: Delta between two fields

Test123 — Thu, 16 Feb 2012 19:13:46 GMT

Thank you Ernesto, that work's Great, thanks for the help.

Re: Delta between two fields

ErnestoM — Wed, 15 Feb 2012 16:13:13 GMT

All credit goes to Jimmy - he posted this concept a while back in another discussion. :)

Re: Delta between two fields

Skarn — Tue, 14 Feb 2012 23:11:38 GMT

Cool formula - using the logic test as a value - cool.

Re: Delta between two fields

ErnestoM — Tue, 14 Feb 2012 17:52:56 GMT

Hi,

Try a formula like this:

(field1-field2) * (1 - 2 * ((field1-field2) < 0))

Hope this helps.

Delta between two fields

Test123 — Mon, 13 Feb 2012 14:57:25 GMT

I need a quick help on this, i have three fields field1, field2 and field3. i have to set value of field3, to the difference between field1 and field2, example:100-50=50 and 50-100= 50 it should not display negative number. thank you