Thanks, that is an excellent idea.
I was begining to think in that direction but I thought I should be able to get it to work in its initial code.
Assigning values to individual results maybe easier than compounding lots of IF statements.
Sorry, it does work, but I don't know how since when I first re-coded the statement it didn't. I closed CR and re-started the report, then it worked!!!
Again, thanks, I think that cheking for nulls and greater than zeroes is what did it.
Thanks for the prompt reply. I've tried your suggestion, same results.
And no, there are no cases where both PLUS & SUB or UNSUB amounts are present, its either PLUS or SUB, or UNSUB, but sometimes there are SUB & UNSUB amounts.
It seems so simple (this is common programming code in other...
Why is it that the statement below only works for the first IF condition, I can switch the statements around but only the first condition works:
if ({GUARANTEE_REPORT.PLUS_CERTIFIED_AMOUNT} > 0)
then "PLUS"
Else
if ({GUARANTEE_REPORT.SUB_CERTIFIED_AMOUNT} > 0)
then "SUB"
else
if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.