QV is getting the 0% as a null when it supposed to include it as 0% in the expression

[xarapre7]

Hi!

In my expression for a straight table, QV is getting the 0% as a 'null' when it supposed to include it as the actual 0% in the expression.  Because of this, I'm getting 86% instead of 83%.  What is the correct expression to have it as the actual 0%?  My expression is:

IF(NOT ISNULL(SUM(Calls)/SUM(CallsOffered)),SUM(Calls)/SUM(CallsOffered), 0).  Please see attached for the sample. 

Thank you for your help in advance!

[oscar_ortiz]

Preciosa,

This looks to be a Divide by Zero issue.  Have you tried modifying your expression to something like this?

If ( SUM(CallsOffered) =0, 0, SUM(Calls)/SUM(CallsOffered) )

Good luck

Oscar

[oscar_ortiz]

Having a second look, maybe you can use Count() instead of Sum().

[xarapre7]

It worked!  Thank you for your help Oscar!!!

[oscar_ortiz]

Preciosa,

If you have found the advice helpful or correct, please close the post.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Oscar