Different format for multiple local key figures

[peter_casper]

Dear community,

is there a way to apply different formatting options for different locally defined key figures in Excel?
So for example local kf1 shall be formatted as number wheres local kf2 as percentage.

I tried to apply different formatting by adding an entry to the formatting sheet based on "specific selection > Local Member > [Name of the local member]". But the system does not take this entry into account, i.e. formatting for this particular local member does not change (even if I unflag the standard formatting for local members just to exclude a sequence issue where one format overrules another one).

I also recognized that the Excel add-in formatting sheet does not keep the union flag on the multiple selection overview in case I add multiple local key figures to one configuration entry. However this would not bother me as I can simply add an entry per local key figure.

BR, Peter

[piyush_parekh · Accepted solution]

Hi Peter,

Please check the local key figure name maintained in Advanced >> Report Editor

Local member name maintained over there should match with local member name to be mentioned in the Specific Selection. Add 2 row items separately for 2 local members in the formatting sheet.

Hope this helps!!

Regards,

Piyush

[peter_casper · Accepted solution]

Hi Piyush,

thanks a lot for your help. Actually this was the missing piece which was also not documented anywhere. I already played around w/ the naming but wasn't aware that the internal local key figure name differs from the "description" which will be shown in the Excel.

So in essence the IBP add-in creates an internal naming for any local key figure following this rule:

LocalMemberXXX, where XXX stands for an incremantal integer value starting w/ 000 for the first local member, 001 for the second and so on. Instead of using ones custom description it's important to use the technical name "LocalMemberXXX". Afterwards the formatting gets applied accordingly.

Cheers, Peter.