Getting rid of "None" during data fetch in IBP

[sourojit_pal]

Hi Experts,

One of my KF: KF1 is at PerProd Level. So when I bring in this KF wrt to other KFs belonging to PerProdLoc, I am getting "(None)" for KF1 under LocID. I want to replace "(None)" with Blank. Is that possible? If so how?

Regards,

Sourojit

[Former Member · Accepted solution]

Hello Surojit,

Are you talking about ' data fetch on to excel' ?

Because in Analytics app (Web UI), its pretty much straight forward

And if its about Excel sheet UI, i think there's has to be a way to data-dress in EPM Formatting sheet ?

Will post, if i find a way to crack this? Please do the same, if u find any 🙂

[sourojit_pal]

Yes Venkat,

I want this to happen in Excel UI.

Regards,

Sourojit