This content has been marked as final. Show 3 replies
I am using an if statement in statement which shows the wrong result.
The if statement that i have used is as follows -
if(x<z or y<z,'x or y< z',
if(x>z or y>z,'x or y> z','x or y = z')) as "xyzpap".
But when i use it to create a pie-chart -
1) "xyzpap" as Dimension
It gives wrong values for 'x or y<z', 'x or y >z' and 'x or y = z'.
How do i tweak the expression to get the correct result?