Decimal Issue in Planning view

[Former Member]

hi gurus

In my planning view i don't want to see decimals for consensus forecast . I have changed the KF settings but still seeing decimal. Any comments ?

Thanks

[former_member235875 · Accepted solution]

Hi

Himanshu Bharwai

Also you can go to the EPMFormattingSheet  on you template,go to ->Dimension Member/Property Formatting find the colum Row and find your KF, then go to USE-->FontColorIndex | Pattern(double click) then choose Number Format, and finally on the Data right click cell format and then change the format of the KF.

I hope this can help you

Regards

Jorge

[Former Member · Accepted solution]

Thanks Jorge

I went to EPM sheet, selected the KF rows and changed the cell format. Then i updated the template and it worked !!