Hello,

I am trying to use an expression within a set analysis, but I cannot make it work.

I have an expression called Lost_Minutes which is calculated as follows: 

=SUM(th_late_st)
+SUM(th_early_fin)

I would then like to use this expression in a set analysis in the same chart, so that I can count the number of times (using the th_ses_id field) the result in the Lost Minutes expression is greater than 90.

=COUNT({<[Lost_Minutes]={">90"}>}th_ses_id)

However, this returns a count total of all possible values, instead of limiting it to just those where the Lost Minutes are greater than 90.

When I replace the Lost_Minutes expression with a dimension, as below, it works correctly.

=COUNT({<[th_early_fin]={">90"}>}th_ses_id)

Is it possible to use the Lost_Minutes expression in the set analysis, and if so, what am I doing wrong?

Thanks,

Paul