Set Analysis

[risabhroy_03]

I have 2 date fields Invoice_Date_GMT & Max_Invoice_Date

I want to sum my Quantity where Invoice_Date_GMT = Max_Invoice_Date.

I tried -     Sum({<[Invoice_Date_GMT] = [Max_Invoice_Date]>}Quantity)  but it came as 0.

Both the dates are in the same format.

Please help.

[jmartineze]

Hi,

you can try 

sum(if([Invoice_Date_GMT] = [Max_Invoice_Date],Quantity))

or maybe

Sum({<[Invoice_Date_GMT] = {$(=max( [Max_Invoice_Date]))}>}Quantity)