Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try Aggr() function
ex- Aggr(sum(Amount1),Name)
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.