Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i want to sum 3 last month on one month
For jan. 2019 i want to sum 7+11+7+19, how i can do this ?
the set analysis is : Sum( {$<
FACT_Type = {"Mouvement"},
DateAnalyse={"<=$(=Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)))"}*{">=$(=addmonths(Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)),-3))"}>
} _Qte_consommee_local)
Best regards,
Sophie
May be you need one of these 2
RangeSum(Below(Sum({$< FACT_Type = {"Mouvement"}, DateAnalyse={"<=$(=Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)))"}*{">=$(=addmonths(Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)),-3))"}> } _Qte_consommee_local), 0, 4))
or this
RangeSum(Below(Sum({$<FACT_Type = {"Mouvement"}>} _Qte_consommee_local), 0, 4))
HI,
You don't need to intersect set analysis for this propousal
Sum( {$< FACT_Type = {"Mouvement"}, DateAnalyse={"<=$(=Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)))>=$(=addmonths(Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)),-3))"}> } _Qte_consommee_local)
Hi,
Try these
=rangesum(above(Sum( {$<
FACT_Type = {"Mouvement"},
DateAnalyse={"<=$(=Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)))"}*{">=$(=addmonths(Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)),-3))"}>
} _Qte_consommee_local),0,3))
Regards
Mustaq
May be you need one of these 2
RangeSum(Below(Sum({$< FACT_Type = {"Mouvement"}, DateAnalyse={"<=$(=Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)))"}*{">=$(=addmonths(Date(Max({<FACT_Type={"Stock"}>} DateAnalyse)),-3))"}> } _Qte_consommee_local), 0, 4))
or this
RangeSum(Below(Sum({$<FACT_Type = {"Mouvement"}>} _Qte_consommee_local), 0, 4))