Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I need to calculate only value before 0 did not need the value when the value is being start 0 .
When the value is start 0 then rest of the value is going to convert 0 to 1
Ex: i need green count upto 1,1,1,1,1,1,...before 0 value no need to calculate after 0 value
Thanks in Advance,
Swarno
Hi, I'm not sure to have undertood it.
If you want only rows with green=1 you can add a contion to the oteher columns, something like:
If([ExpressionForGreen]=1, [ColumnExpression])
It can also be done with calculated dimension, somehitn like:
Aggr(If([ExpressionForGreen]=1, Date) ,Date, [Station Id])