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

[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