topic Re: 2 different results in QlikView

2 different results

dseelam — Wed, 19 Sep 2018 14:26:40 GMT

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,

kfoudhaily — Wed, 19 Sep 2018 15:07:07 GMT

can you provide details about your data model?

maybe a screenshot?

mikaelsc — Wed, 19 Sep 2018 18:03:33 GMT

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)