sum with 2 conditions

[#1]

Hi qlik folks

I'm freaking out to make an formula to sum with two statements basically is like that

Sum(<{[Invoice Type] ={'SF','SFT'} {<[BU ={'710'}>} [NET SALES TOTAL]>)

or

Sum(<{([Invoice Type] - {'SDO'})} {<([BU ={'710'})>} [NET SALES TOTAL]>)]

Cheers!

[#2]

I've also have tried this one

Sum({$<[Invoice Type]-={‘SDO’}, [BU] = {720}>} [NET SALES TOTAL])

[Anonymous]

Hello,

Try putting the 720 value in single quotes.

Example:
{'720'}

[#4]

HI Sean Tks for your resposnse

I did... but dont change at all

I have suceess only when I put the Invoice Type as List Box and the Business Unit into the formula

sum({$<[BU]={720}>} [NET SALES TOTAL])

[#5]

Hello Leo,

Try this:

Sum({$<[Invoice Type] = {'SDO'}, [BU]={'710'}>} [NET SALES TOTAL])

Hope it helps

Rgds

Ema

[jagan]

Hi,

Try this expressions

Sum({<[Invoice Type] ={'SF','SFT'} , [BU ={'710'}>} [NET SALES TOTAL])

or

Sum({<[Invoice Type] -= {'SDO'}, [BU ={'710'}>} [NET SALES TOTAL])

Note: Qlikview will show errror near -= but it works.

Hope this helps you.

Regards,

Jagan.

[SunilChauhan]

try this one

Sum({$< [BU] = {720}>} [NET SALES TOTAL]) - Sum({$< [Invoice Type] = {'SDO'}>} [NET SALES TOTAL])

[alkesh_sharma]

Try this..

Sum({<[Invoice Type] ={'*'}- {'SDO'}, [BU ={'710'}>} [NET SALES TOTAL])

[#9]

This might helpful to u

Sum({$<[Invoice Type] = {'SDO'}, [BU]='710'>} [NET SALES TOTAL])