Sum if

[#1]

Hi there,

I require assistance with creating a single sum from these to statement

SUM({<Cores={'<=4'},HardwareStatus={'Base'}>}Processor * 0.20)+

sum({<Cores={'<=4'},HardwareStatus={'New'}>}Processor)

Regards

[CELAMBARASAN · Accepted solution]

It is possible only if you have the load in inline like

StatusMultiplier:

Load * Inline [

HardwareStatus, multiplier

Base, 0.20

New, 1];

Then you can simply use

SUM({<Cores={'<=4'},HardwareStatus={'Base', 'New'}>} Processor * multiplier)

Hope it helps

[#3]

Perfect, thank you

[mr_janne]

sum({<Cores={'<=4'}>} Processor * if(HardwareStatus='Base',0.20,if(HardwareStatus='New',1,0)))

[israrkhan]

try this:

(SUM(if({<Cores={'<=4'},HardwareStatus={'Base'}>})Processor) * 0.20)  +

sum({<Cores={'<=4'},HardwareStatus={'New'}>}Processor)

or this

num(SUM(if({<Cores={'<=4'},HardwareStatus={'Base'}>})Processor) * 0.20, #,##0.00)  +

sum({<Cores={'<=4'},HardwareStatus={'New'}>}Processor)

[#6]

#Israr, there is an issue with the syntax

[israrkhan]

' ' are missing in the second expression, around number format  '#,##0.00'

[#8]

Try that, still doesnt work

I think the problem is by the sum (if(