topic Multipication with a 0 in QlikView

Multipication with a 0

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to work out the value of an order with a sales price of 0. Obviously this is 0. however,not all orders have a quantity of zero.

The calculation I have used is

=if([Sales FC Unit Price]=0,'0',
if ([Sales FC Unit Price]>0,
[InvHistory Transaction Quantity] * [Sales FC Unit Price])

This works fine for all the orders that have a price and quantity however, for any records with a sales price of 0 they disappear. I have unchecked the Suppress Zero-Values in the presentation tab of the expression but not joy.

Can anyone help, I guess there is a simple way round this

Re: Multipication with a 0

sunny_talwar — Thu, 23 Mar 2017 15:42:33 GMT

What if you do this

=if([Sales FC Unit Price]=0, 0.00000001,

if ([Sales FC Unit Price]>0,

[InvHistory Transaction Quantity] * [Sales FC Unit Price])

Re: Multipication with a 0

Thu, 23 Mar 2017 16:00:25 GMT

Perfect thank you very much