Set analysis - calculation with dates

[annanirvin]

Hi all.

Can someone please help me with this calculation?

=Num(NumericCount (DISTINCT {1<Ä_slag={'AEF'}, Substatus={'Inkomna'}, Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}Ärendeid) / Sum({<Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}P_AEF), '# ###%')

NumericCount (DISTINCT {1<Ä_slag={'AEF'}, Substatus={'Inkomna'}, Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}Ärendeid) gives the correct answer as well as Sum({<Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}P_AEF) but not when I combine them. I suppose the problem has to do with the Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"?

Best regards,

Anna

[annanirvin]

Thanks, but the sum is 4,00.

[sunny_talwar]

May be this thread can address you confidentiality concerns

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample