Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
how can i create colculte the last 6 month in the next formula :
sum ({$<_Flag={Inv,InvAdel}>}[kg])
thanks'
yarin
Try this:
sum ({$<_Flag={Inv,InvAdel}, Date={">=$(=MonthStart(Today(), -6))"}>}[kg])
Felipe
hi ,
thanks' but the calculte is without the month that in last year , for exm:
my dimension is 2014 may,
i expect to see the resoult for apr,mar,feb,jan,dec(13),nov(13).
is it possible ?
yarin.
sum ({$<_Flag={Inv,InvAdel}, Date={">=$(=MonthStart(Max(Date), -6))<$(=MonthStart(Max(Date)))"}>}[kg])