Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])
May be try this
RangeSum([UK Invoice Item Unit Price], -[UK Item Master Rebate Unit Price]) * [Stock Estimated Balance UK]
Thank you for taking the time to reply, this worked perfectly.
Thanks
Daniel
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