if... then do the maths question
Hi, everyone, here's my problem:
If the field data entry is smaller than 5000 then the result is 0, if greater then process the calculation... say + 5%
Thanks in advance.
Case ( Entry < 5000 ; 0 ; Entry * 1.05 )
Case ( Entry < 5000 ; 0 ; Entry * .05 )
Thank you, it did work. But I face any other problem, since I also want something like this:
Case ( Entry > 20000 ; 1000 ; Entry * .05 )
How can I combine this two script and result in a single field?
If I understand correctly, you want:
Entry < 5000 ; 0 ;
Entry > 20000 ; 1000 ;
Entry * .05
Retrieving data ...