Replacing '-' with '0' in pivot table

[Abhi999]

I used below query but still showing '-' in table

IF(ISNULL(count(order))='-', 0,count(order))

[dmpilars]

Hello!

The output of the ISNULL function will be -1 for TRUE, you cannot compare its output with a character because it is a boolean output, TRY:

IF(ISNULL(count(order))=-1, 0,count(order))

Best Regards, DMPS

[Abhi999]

Thanks for quick reply,but still I can see '-' symbol in table

[Madhur]

Hi @Abhi999 ,

Count() and Sum() are two aggregate function that do not return the NULL value. If the value do not exist than 0 is returned, So there must be problem somewhere else.

[Abhi999]

Then why I am getting '-' in pivot table

[dmpilars]

A calculation error, for example a division by 0, or can you have a dimension for which there are no calculation values ​​for the measure?

[Madhur]

Can you share the sample qvf to check ?

[Abhi999]

Sorry I can't able to share qvf because it is highly ristricted. I will share some example.

[dmpilars]

For example, if you have a table like this:

and you try

you will have some options in your dimension for which there is simply no data

Will your dataset be something similar?  This is something that comes to mind very quickly and simply to illustrate one of the reasons for this type of output.

[Abhi999]

Yes similar.