Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,,
Have you tried
Num(IF(sum([Open])>0, sum({$<[30+ Days]={1}>} [Open]) / sum([Open]),'#,###0.0%'))
Currently what is the status?
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..
Hahaha, That is your data. You should test