Calculation using date

[#1]

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

[buzzy996]

means "for Maximum date -7"?pls.

[its_anandrjs · Accepted solution]

Hi,

Try to use SET analysis expression

Sum({<ShipDate = {'$(=Date(Max(ShipDate)-7))'}>}  Quantity)

Also check the attached solution

Regards,

Anand

[#4]

yes, I need to calculate

=Sum({<ShipDate={$(#MaxDate)}>}Quantity)

Where MaxDate  =Date(Max(ShipDate)-7) but its throwing an error.

[#5]

Thanks Anand.

It was a great help from you

Regards

Priyanka Pandey