Rangesum and Nulls

[0li5a3a]

Hi There,

I have the following scenario :

Dimension : Month_Year_Created

Expression1 :count({<[Resolved Within SLA] = {'Met SLA'}>}[Resolved Within SLA]) / count(total <Month_Year_Created> [Resolved Within SLA])

Expression 2: count({<[Resolved Within SLA] = {'Missed SLA'}>}[Resolved Within SLA]) / count(total <Month_Year_Created> [Resolved Within SLA])

Expresion 3: [Contractual Target]

Expresion 4: RangeSum(Above(count([Met SLA]),0,RowNo())) / RangeSum(Above(count(total <Month_Year_Created> [Resolved Within SLA]),0,RowNo()))

The problem which I have is that the Expression 4 is treating nulls like 0 and that is the reason my chart looks like below . I already

the ticket all the buttons to exclude the nulls but the chart is not right.

Could someone help me with?

Regards,

C

 

[rubenmarin · Accepted solution]

Hi Constantin, maybe adding a condition to expression4, i.e.:

If(Month_Year_Created<Monthstart(Today()), RangeSum(Above(count([Met SLA]),0,RowNo())) / RangeSum(Above(count(total <Month_Year_Created> [Resolved Within SLA]),0,RowNo())))

[0li5a3a]

thanks, that is it:)