Calculation based on where clause

[diana_ritere]

Hi,

I've got one dimension named Stage. Stage may contain values Working, Idle, Cancelled.

I'd like to select only those values which are Working and then calculate drop off rate, e.g.,

([Idle]-[Working])/[Working]

Obviosly this won't work as mine are fields not dimensions.

If I use

match( str, expr1 [ , expr2,...exprN ])

I am unsure on how the expression should be written.

Any help?

[justISO]

Hi, not sure where you prefer to do your calculation, in load script or report level, but in report level you can try to use set analysis approach, something like this:

( sum({$<Stage='Idle'>} your_value) - sum({$<Stage='Working'>} your_value) ) / sum({$<Stage='Working'>} your_value)