Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I try to have the sum of the quantity for one day .
When I made that for year -1 it's work but not for the current month
Sum({<
[Filtre CA vente] = {"Oui"},
[Type date]={'BL vente','Facture vente'},
Date = {"<=$(=Date(RangeMin(Max(Date),Today())))"},
AnnéeMois={"$(=MonthName(RangeMin(Today(),Max(Date))))"}
>}[Quantité vente])
It give me the total of the month and not just for today
Can you explain why it doesn' t work ?
Hi
Try like below
Sum({<
[Filtre CA vente] = {"Oui"},[Type date]={'BL vente','Facture vente'},Date = {"$(=Date(Max(Date)))"}>}[Quantité vente])
it will display the latest date .
Hello I sorry
But I have date on the futur so it's doesn't work