I two calculated fields:
TotalExpenses
TotalPrepaid
If TotalExpenses > TotalPrepaid, I want it to display the amount. If it is less than zero, I only want it to display zero. I can't get it to work. I tried this, but it isn't working:
if (TotalExpenses.rawValue > TotalPrepaid.rawValue) then
TotalExpenses.rawValue - TotalPrepaid.rawValue;
elseif (TotalExpenses.rawValue < TotalPrepaid.rawValue) then
Totals = "0" ;
endif
Thanks, Anne