Not Considering Null Values in KPI Box

[QVUser1]

Hi All,

I have the following Scenario Where Stock and sales fields are from different Tables.

I want to find the null values based on this MATNR and SKU for Sales

I have tried Using

• ISNull
• Len(Trim(Sales))    
• Isnull(Sum(Sales))

But None of them have Worked .

Expression Requirement : If Sales is not null, I need to count no of SKU's  in KPI box

[Kushal_Chawda]

@QVUser1  try below. 

=count({<Key ={"=sum(Sales)>0"}>}SKU)

=count(distinct{<Key ={"=sum(Sales)>0"}>}SKU)

where Key is primary key of the table.

[QVUser1]

HI Kushal,

Thanks for the reply . but this does not worked.

Actually  my calcualtion  is  :

If(IsNull(Sales),Condition)  trying to show it in KPI Box 

[Kushal_Chawda]

@QVUser1  Not sure but sample data with expected output might get you better help