expression

[upaliwije]

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

[terezagr]

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))

[Peter_Cammaert · Accepted solution]

Like this?

=sum(IF (Not IsNull(Sent_Date), Amount))

[upaliwije]

thanks