February 6, 2013 at 11:41 am
This is working great but I need to add another piece and my brain just cant get it. So, Thanks
([CONV CODECURNRC] == "CAD" ? [CONV AMTNETTOT] - [CONV Payments] : ([CONV AMTNETTOT] - [CONV Payments]) * [CONV EXCHRATEHC])
What I need to do is evaluate the above statement and if it evaluates to < = 0 THEN 0, Otherwise evaluate just the above statement.
February 6, 2013 at 1:32 pm
You could add another level of nesting:
Expression < 0 ? 0 : Expression
where expression is the entire statement you currently have.
Or - slightly unorthodox - add another derived column transformation after this one and you can build another expression using the column you have just created. Avoids the nasty nesting.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
February 6, 2013 at 1:41 pm
I figured this one out by using the && operator. Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply