Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to calculate sales when date equals max date of the selected period.
Can someone helps me?
For example :
For week 2017/44, I want to display sum of the max date of this week, so the sales of the 05/11/2017 (and not the sales of the complete week).
Thanks and regards
Or this
FirstSortedValue(Aggr(Sum(nb_transaction), dt_jour), -dt_jour)
Try this
Sum({$ <dt_jour={"$(=Date(max(dt_jour)))"}>} nb_transaction)
Or this
FirstSortedValue(Aggr(Sum(nb_transaction), dt_jour), -dt_jour)
Hello,
Formula with FirstSortedValue is working!
Tanks a lot!
Hello,
I bounce on my previous question : what would be the formula if I add a cyclic group as dimension?
Thanks and regards
Sara
Would need to see what dimensions you have and what is the output you expect
try
getcurrentfield('Cyclicgroupname') if you add cyclic group as dimesnion
Hello,
I had an example on my previous answer.
There are 2 formulas: when I use dimensions in a cyclic group and when I don't use a cyclic group.
Don't hesitate if you need more precision.
Thanks & Regards
May be this
Sum({$<dt_jour = {"$(=max(dt_jour))"}>} nb_transaction)
It works fine! Thanks a lot.
Just to understand :
Why my formula did not work? -> Sum({$ <dt_jour={'=max(dt_jour)'}>} nb_transaction)
In the Set analysis, what is the difference between {'=max(dt_jour)'} and {"$(=max(dt_jour))"}?
Thanks and regards