Dynamic reference line

[nareshthavidishetty]

Hi,

We need to create a dynamic reference line to the line chart.

Expression used : =IF(isnull(num(sum([Open]),'#,##0')), Null(), Num( num(sum({$<[30+ Days]={1}>} [Open]),'#,##0') / num(sum([Open]),'#,##0'),'#,###0.0%'))

Based on the selection the chart reference line should reflect dynamically.

Thanks,,

[avkeep01]

Have you tried

Num(IF(sum([Open])>0, sum({$<[30+ Days]={1}>} [Open]) / sum([Open]),'#,###0.0%'))

[Anil_Babu_Samineni]

Currently what is the status?

[nareshthavidishetty]

Hi,

I'm getting a reference line.

But doubt is reference line is the average of results right. But we have used the direct expression results.

Is it correct?If not please share the right one .

Thanks..

[Anil_Babu_Samineni]

Hahaha, That is your data. You should test