Need Count before 0 value

[swarnosonah]

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

[rubenmarin]

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])