on 03-28-2012 1:33 PM
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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.