Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Gurús,
I'm trying to apply a simple calculation (actually it's much more complex but I'm simplifying it just as an example) where I need to see the Billing Amount aggregated by Material. Something like:
Sum(Aggr(Num(Sum( [Billing Amount in LC])), Material))
If I see the result in a Table and select one single month (like Fabruary 2023), the result changes as if I see in the table all the months of 2023 (the correct value appears when I select one single month). I attach two screenshots:
And if I unslect fabruary, his result changes:
Any idea about why this behaviour is happening??
Thanks in advance.
Regards,
Jordi
Sum(Aggr(Num(Sum( [Billing Amount in LC])), Month_ES, Material))