Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
the below formula does not sum the Or 'Updated transaction',
I need both New and Updated transactions to be summed, right now only the New transactions part work.
Any ideas why?
SUM(IF([ILM RESPONSIBLE]='YES',IF([TRANSACTION STATUS]='New transaction' Or 'Updated transaction', AMOUNT)))
Try:
SUM(IF([ILM RESPONSIBLE]='YES',IF([TRANSACTION STATUS]='New transaction' Or ([TRANSACTION STATUS]='Updated transaction', AMOUNT)))
Try:
SUM(IF([ILM RESPONSIBLE]='YES',IF([TRANSACTION STATUS]='New transaction' Or ([TRANSACTION STATUS]='Updated transaction', AMOUNT)))
thanks!