I am trying to have my CURRENT (number calculation) field display results (DESIRED) based upon 4 scenarios. Using a CASE function. Two work, two do not. The CASE statement shown in example is one, I've separated to make it easier to distinguish the scenarios.

Edited July 3, 20223 yr by Raizel

Not sure if this is what your after:

Case ( 
amount < 0 ; -( units * per unit )  ;
amount > 0 and units > 0 ; units * per unit ;
amount > 0 and IsEmpty ( units ) ; balance * per unit ;
amount > 0 and units > 0 ;units * per unit ;
amount > 0 and units < 0 ; Abs( units * per unit )
)

 

Not sure why the case condition is "AMOUNT" and not "UNITS" as I used.