Skip to Content

Problem with null value in IDT.

Hi,

I am calculating the Sales Quantity like (Debit Qty- Credit Qty)

SUM(CASE WHEN 0DEB_CRED ='D'THEN  0QUANT_B  END)-SUM(CASE WHEN 0DEB_CRED ='C'THEN  0QUANT_B END)

in Information Design Tool

In this when Credit value is null its taking Debit value also as null.

Ex: Debit is 10 and Credit is null its taking as 10-null= null.

Could you please suggest me how to resolve this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 28, 2012 at 07:19 PM

    I haven't looked into the formulas too much, but could you not do an if statement where you check if the value is null, and if it is, replace it with 0 instead?

    Add comment
    10|10000 characters needed characters exceeded