Sum Results from 2 Expressions in Pivot Table

[#1]

Here's an easy question (I hope) from a Qlikview newbie.  In a Pivot chart i have 2 expressions:

= sum(if(IsNull(TCWIPRemoveDate),TimecardWIPAmt))

and

= sum(if(IsNull(CostCardIsNB),CostcardWIPAmt))

I just want to add a third expression to the pivot chart that is a SUM of the other 2 values.   Can someone assist?  I think i just have a syntax issue, should be easy.

Basically = sum(if(IsNull(TCWIPRemoveDate),TimecardWIPAmt)) + sum(if(IsNull(CostCardIsNB),CostcardWIPAmt))

[MayilVahanan · Accepted solution]

HI,

     Try like this,

     =Column(1) + Column(2)

     Hope it helps

[#3]

Funny, I knew it would be easy, just not THAT easy!      Thank you so much for the quick reply.

Richard