Report : Display 0 where Blank

[kalyanswarna]

Hi, i have requirement in my report for some of the keyfigures i need to display 0 where it is blank.

in the report we have enabled Masterdata results for all the characterstics that means they will display when there is no posted values in that cases need to dispaly 0 instead of Blank.

Please let me know if anyone has sol.

Thanks,

Kalyan

[former_member186445 · Accepted solution]

what we did:

let's say you want to do this for KF1.

create calculated key figure with defintion : KF1 + 0

then use the calculated kf in your query. it will always show 0 instead of blank.

M.