Displaying zero in the report when no data in database

[Former Member]

Hi,

Can you please advise me how to achieve the below request.

In my report for few months the revenue is not having any data either Zero or null value in the database.

But the customer wants to display Zero in the revenue column which is not having data.

Please help me to achieve the report variable.

Thanks,

Lavanyaa TP

[jyothirmayee_s · Accepted solution]

Hi,

You can create a variable in webi:

=if(not(isnull([Rev])) or [Rev]="") then 0 else [Rev]

Thanks,

Jothi

[gleo_SRAM · Accepted solution]

Hi Jothi,

Will this be fool proof?  If the customer has no sales at all, how will your formula add the Customers name to the report?

Is this not a requirement to report on master data rather than transactional data.

With regards

Gill

[jyothirmayee_s · Accepted solution]

Hi Gill,

Sometimes user dont want to see the empty cells rather prefer 0 which doesn't make any difference.

Yes, you can have master data rather a transactional data .

What is your datasource Lavanya?. you can do the changes on the backend rather doing it on report level  as Gill suggested.

Thanks,

Jothi

[Former Member · Accepted solution]

Hi Gill\Jothi,

Thanks for your reply.

I agree with your points.

The request is from customer and thats how they want to display Zero for the month when the measure object is having a zero value.

Data source is tera database.

Thanks ,

Lavanyaa TP

[Former Member · Accepted solution]

Hi Lavanyaa,

You may try a custom format in which you can define required format for Positive and Negative Values and can put 0 under Undefined.

Regards,

Yuvraj

[Former Member · Accepted solution]

Hi Lavanyaa,

You can use IsNull() function to acheive this.

=if(IsNull([Revenue]);0;[Revenue])

Thanks,

Kirthi