Please help

[Anonymous]

Hello,

Could you help me to select only date, where Result<70%?

Please see attached file.

Thanks,

[udit_kumar_sana · Accepted solution]

Hi,

you can write this in your straight table expressions:

1.)For Result:-

if(((Count({<MYear={'$(=MonthName(max(MYear)))'}, Result={'Yes'}>}Result)/

Count({<MYear={'$(=MonthName(max(MYear)))'}>}TOTAL<submitDateTime>Result))*100)<=70,((Count({<MYear={'$(=MonthName(max(MYear)))'}, Result={'Yes'}>}Result)/

Count({<MYear={'$(=MonthName(max(MYear)))'}>}TOTAL<submitDateTime>Result)))*100)

2.)for Sample size:-

=if(isnull(column(1)),0,Count({<MYear={'$(=MonthName(max(MYear)))'}>}TOTAL<submitDateTime>Result))

Regards,

Udit

[Anonymous]

Thank you so much