Report 2007

[Bryan]

Hi
I have a report and need to do some calculations. For most of it the calcs
are ok, I just need to show for example, if a=20 and b=30 I want the
calculation a-b to be equal to 0 and not -10, and b-a=10. I then need to
multiply another number by the result. I do not want to multiply by a
negative number. (total<0,0,total) does not work.
Thank you
Bryan

 

[KARL DEWEY]

if a=20 and b=30 I want the calculation a-b to be equal to 0
IIF([a]>, 0, [a]-)
IIF(IIF([a]>, 0, [a]-) = 0, [YourNumber], IIF([a]>, 0, [a]-)
* [YourNumber])