When the o/p of current expression is NULL use output of above

[qlikviewforum]

In the below pivot table as you see in the row=6,10 and 23 the value of the % Cust Vol is NULL. So what we prefer to have is whenever the output of the expression is NULL we would like show output of the above expression (i,e) for 6th row=81%,10th row=81% and 23rd row=78%.

Formula,
%Cust Vol= ([Cust Buy]+[Cust Sell])/([Buy]+[Sell])

Since the value of [Cust Buy],[Cust Sell],[Buy] and [Sell] is ZERO the output of 6,10 and 23 is NULL.

So can you please help me out to overcome this issue?

[qlikviewforum]

I have already marked the helpful answer. May I know how to close to thread?

[sunny_talwar]

Look here to know how to close threads -> Qlik Community Tip: Marking Replies as Correct or Helpful