Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I need to calculate sum of quantity for Maximum date -7.
For more reference you can use the two attachment.
Please guide.
Thanks in advance
Priyanka Pandey
Hi,
Try to use SET analysis expression
Sum({<ShipDate = {'$(=Date(Max(ShipDate)-7))'}>} Quantity)
Also check the attached solution
Regards,
Anand
means "for Maximum date -7"?pls.
Hi,
Try to use SET analysis expression
Sum({<ShipDate = {'$(=Date(Max(ShipDate)-7))'}>} Quantity)
Also check the attached solution
Regards,
Anand
yes, I need to calculate
=Sum({<ShipDate={$(#MaxDate)}>}Quantity)
Where MaxDate =Date(Max(ShipDate)-7) but its throwing an error.
Thanks Anand.
It was a great help from you
Regards
Priyanka Pandey