topic Re: help with calculation when dimension is null in QlikView

help with calculation when dimension is null

davyqliks — Sat, 16 Nov 2024 00:12:17 GMT

Hi,

I have the following calculation:

([UK Invoice Item Unit Price] - [UK Item Master Rebate Unit Price]) * [Stock Estimated Balance UK]

I am finding that if the return for [UK Item Master Rebate Unit Price] is Blank, the calculation returns a zero.

e.g

0.02652 - 0 * 25500 should be 676.26 but i am returning a 0

while 0.0136 - 0.0066 * 1515 returns the correct 10.60

I wonder if anyone can assist in adding an if clause.... if that is the best way to go as i cannot get this right.

Thanks

Re: help with calculation when dimension is null

jwjackso — Mon, 03 Aug 2020 18:48:04 GMT

Try

If (IsNum([UK Item Master Rebate Unit Price],

([UK Invoice Item Unit Price] - [UK Item Master Rebate Unit Price]) * [Stock Estimated Balance UK],

[UK Invoice Item Unit Price] * [Stock Estimated Balance UK])

Re: help with calculation when dimension is null

sunny_talwar — Mon, 03 Aug 2020 19:36:51 GMT

May be try this

RangeSum([UK Invoice Item Unit Price], -[UK Item Master Rebate Unit Price]) * [Stock Estimated Balance UK]

Re: help with calculation when dimension is null

davyqliks — Tue, 04 Aug 2020 10:58:23 GMT

Thank you for taking the time to reply, this worked perfectly.

Thanks

Daniel

Re: help with calculation when dimension is null

davyqliks — Tue, 04 Aug 2020 10:59:26 GMT

Hi Sunny,

Thank you for taking the time to reply, i tried the other method posted first and it worked but wanted to thank you for taking the time to post an answer.

Thanks

Daniel