data not showing but formula is correct

[DrS]

Hi i have just put my calculation sum(Amount1) for Gross Premium(GWP), the fomula is correct but it is not showing the data for some reason, when i use filters to select data it sometimes appears during filtering and once i cancel the filter it goes back to Zero.

Gross premium(GWP) has the issues

[salonibhatia]

hey .. can u share the dashboard?? looks like something wrong with data in backend

[raman_rastogi]

try Aggr() function

ex- Aggr(sum(Amount1),Name)

[jyothish8807]

Hi Drs,

Try this both:

Sum(Total <Name> Sales)

You can add, remove the fields to which it can grouped.

or

if(Sales >=0,Sum(Sale))

Also i recommend to removed the screenshot of your dashboard as it displays a lot of information's about your client, which could be critical.