Count difference

[#1]

Hi,

I have data and wanted to show count of dates if SoldAmt >0 or NULL. If I select any date and count should not consider the selection like ignoring.

Attached data is the example and count value should be 50, but when I use this function I get 52

=NUMericCOUNT({<WeekDate=>}SoldAmt)

Can you pls suggest.

Thanks,

[JonnyPoole · Accepted solution]

Here is a formula that will work for you:

=sum( {$<WeekDate=>} if (aggr( sum( {$<WeekDate=>} SoldAmt), WeekDate)>0,1))

[#3]

It is working as expected and good solution.

Thanks,