Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
Please assist I am using the below formula to get the total sales by agent .
=sum(aggr(Total max([WF Sales]),Agent))
How do I sum up the results that I get from this formula because it works fine when I make a selection for one day but more than one day I get incorrect number.
Try to replicate the below
Yes i'm using date filters on the front end.
E.g
Sales for the 2st of March = 800
Sales for the 3nd of March = 650
And when I select the 1st and 2nd at the same time I get = 899 instead of 1450 that's why I say it works fine only for one day.
I have included day on my expression and it solved my problem.
=sum(aggr(max([WF Sales]),Day, Agent))