2 different results

[dseelam]

Hello folks,

why this 2 formulas are giving 2 different results even though they using same source columns

Old

Sum({$<ForecastItemMatchInd={"Yes"} >}((SHIPPED_QUANTITY*OVERHEAD_COST) + (SHIPPED_QUANTITY*RESOURCE_COST)

+ (SHIPPED_QUANTITY*ITEMCOST_OPENPO_NOOH) + (SHIPPED_QUANTITY*ITEMCOST_OPENPO_OH)))

New

Sum({$<ForecastItemMatchInd={"Yes"} >}((SHIPPED_QUANTITY*RESOURCE_COST) )) +

Sum({$<ForecastItemMatchInd={"Yes"} >}((SHIPPED_QUANTITY*OVERHEAD_COST) ))+

Sum({$<ForecastItemMatchInd={"Yes"} >} (SHIPPED_QUANTITY*ITEMCOST_OPENPO_NOOH) )+

Sum({$<ForecastItemMatchInd={"Yes"} >}((SHIPPED_QUANTITY*ITEMCOST_OPENPO_OH)))

Thanks,

D

[kfoudhaily]

can you provide details about your data model?

maybe a screenshot?

[mikaelsc]

maybe because a sum of nulls returns a null. (or a sum of numbers and nulls returns null)

try using rangesum instead (will return 0 in case of null values)

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/RangeFunctions/rang...