Hi,
I need total of all products including products with null values but I don't want to show null values for product dimension in chart. If I select suppress null values, total is excluding the values for null as well. What is the best way to resolve this issue?
Below is example,
Data in Table:
Product Value1
P1 10
P2 20
NULL 40
Expected Output:
Product Value1 Formula1 (Excluding Null Record)
P1 10 10+20+40
P2 20 10+20+40
Output I am getting with totals in expression: Sum (Total <Product> Value1) with Suppress Null Value select for Product Dimension
Product Value1 Formula1 (Excluding Null Record)
P1 10 10+20
P2 20 10+20
Output I am getting with totals in expression: Sum (Total <Product> Value1) without Suppress Null Value select for Product Dimension
Product Value1 Formula1 (Without Excluding Null Record)
P1 10 10+20+40
P2 20 10+20+40
NULL 40 10+20+40
I can suppress null records by using if condition, but I want to avoid using if. please advice.
If(IsNull(Product) = -1,0,Sum (Total <Product> Value1))
KJ
