Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Perfect, thank you
sum({<Cores={'<=4'}>} Processor * if(HardwareStatus='Base',0.20,if(HardwareStatus='New',1,0)))
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)
#Israr, there is an issue with the syntax
' ' are missing in the second expression, around number format '#,##0.00'
Try that, still doesnt work
I think the problem is by the sum (if(