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
Yours would have worked as a search string (in the past, have been fixed now in the newer version to only use double quotes) Quotes in Set Analysis. Where as dollar sign expansion gives a single value against which the chart is created. This in your case is the max(dt_jour). The Magic of Dollar Expansions
Hello,
Sorry to bother you again but it seems that the previous formula don't work in any case.
For example if I select several period like week 44 and 45 and if I select year_week in my cyclic group, data for week 44 are equal to 0.
Tell me if you need more details.
Regards
Sara
Please find attached
Great!
Thanks a lot!
Regards
Sara