Nothing selected - Correct; Something selected wrong

[bobbydave]

Hi guys,

I've attached a scorecard I am working on.

When there is no date selected (no year or quarter), the correct results for Index appear as correct as if I had 2014 q4 selected.

But when I select the year as 2014 Q4, then the Index row is incorrect. Needless to say, 2015 Q1 and Q2 are incorrect when I select them also. They should be in or around the 50% 20% 30% mark.

I've attached the qvw for a better understanding.

I've only 2014 Q4, 2015 Q1 and 2015 Q2 data so everything else will be empty

Can anyone see why when no year or quarter is selected, the actual 2014 Q4 data appears but then when I actually select the 2014 Q4, the incorrect data appears?

Any help appreciated.

[sunny_talwar · Accepted solution]

Try this (without {1} in the denominator)

=Num(Aggr(sum([Paid_claims (£)])/sum(TOTAL DISTINCT [Paid_claims (£)]), Legal_Entity), '#.##%')