Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am getting the error "nested aggregation not allowed" for the following expression...
sum(if (FirstSortedValue(Date(TxnDate), TxnDate) = '1/2/2012', Amount, 0))
Can you guys please help me understand the reasons?
I do not have access to the scripts.