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.
February 6, 2013 at 1:41 pm
I figured this one out by using the && operator. Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply