How to show 0 for NULL aggregation

[uditchandna]

For Chart Widgets in SAP Analytics cloud, if there are no rows to aggregate they show "-" . But what we want is to show 0 here

For Table widgets, it show null rows, how do we get to show 0 here as well

Any suggestion

eg:- Let's say I am looking at count of all Sales guys in UK region and let's say there are none, aggregation should show 0 , but it shows "-"

How do we show 0 in SAC widget

[uditchandna]

Hi venkateswaran.k ,

Thanks for your answer. I tried the same in SAC Enterprise embedded in LOBs like SuccessFactors but it seemed it is not supported. It is only supported in the SAC Enterprise edition.

I also see there is an Influence request to SAC on my ask

https://influence.sap.com/sap/ino/#/idea/277061/?section=sectionVotes

I will have to wait for the Influence request being picked up and supported in both LOB and Enterprise edition

[venkateswaran_k]

Hi uditchandna

This is what I was trying to say

1. Create a new calculated column as FCOUNT (formula as below)

IF(ISNULL([your count2 variable] ) , 0,[Fyour count2 variable] ).

Then apply this new Calculated formula FCOUNT in your aggregation.

Regards,

Venkat

[uditchandna]

Hi venkateswaran.k

Let me share with the example .I believe you misunderstood the question. (This is SuccessFactors data connected to SAC)

Let's say This is the data we have

Now this is the SAC widget we created - Numeric Point on Measure Count 2

Count 2 Formula - Count (User Id) [Counts all the User Id]

With No Filter -> Result = 3

Now I apply 2 filters Employment Status = Suspended AND Gender = Female; which results in no rows to be aggregated. Now result we want is 0 , what we are getting is "-"

Screenshot from our system below

[venkateswaran_k]

uditchandna

I put my comment in answer.

[venkateswaran_k]

Hi uditchandna

1. You create a calculated column on Net Sales column.

The formula is simply checking for Null (IsNull 0 - If null then 0 else the amount )

2. Then use aggregation on the calculated column.

Regards,

Venkat

[uditchandna]

Hi venkateswaran.k added the details with data set of what I am trying to achieve and the solution you suggested won't work for me