Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the logbook Done column, I do count(Logbook) and want it to display 0 when count(logbook) returns 0. I have tried turning off suppress Zero-Value, but the value 0 is not showing. Please help me.
Hi @Paknanarn23
You can try this is forcing to show 0 but is in string,
if(count(ABSMG) = 0,'0',count(ABSMG))
If zero values are not suppressed, I would recommend checking if there are any limitations at the dimension level. Each dimension has its own option to show or hide null values, and it may be that the zero values are associated with a combination of dimensions which is suppressed as a result of that.