Set Analysis troubleshooting

[sarafamiglietti]

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

[sunny_talwar]

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

[sarafamiglietti]

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

[sunny_talwar]

Please find attached

[sarafamiglietti]

Great!

Thanks a lot!

Regards

Sara