Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have two fields in my pivot table
Sent_Date
Amount
I want to write an expression to sum the amount where sent_date is not null
Pls help me
Create a flag in your load script as follow:
if(isNull(sent_date),'1',sent_date) as sent_date_flag
In you expression then: If(sent__date='1',' ', sum(Amount))
Like this?
=sum(IF (Not IsNull(Sent_Date), Amount))
thanks