help with calculation when dimension is null

[davyqliks]

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

[jwjackso · Accepted solution]

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])

[sunny_talwar]

May be try this

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

[davyqliks]

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

Thanks

Daniel

[davyqliks]

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