Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
you can try
sum(if([Invoice_Date_GMT] = [Max_Invoice_Date],Quantity))
or maybe
Sum({<[Invoice_Date_GMT] = {$(=max( [Max_Invoice_Date]))}>}Quantity)