Skip to Content
0
Former Member
Jan 23, 2012 at 02:57 PM

BPC7.5 - usage of FORMAT property in ACCOUNT dimension

30 Views

Hello

I am trying to use FORMAT property in ACCOUNT dimension to let the user have his own regional settings and by this way select his separators but not the number of digits.

To use them, in my EVDRE formatrange, I use in parameters NUMBERFORMAT=ACCOUNT.FORMAT

There is something I do not understand, everything seems to be well adapted except a case :

- when I put 0 in the format, my figure is displayed without decimal then in excel, the format applied in excel is a number without decimal

- when I put #,##0, the number is applied with the thousand separators

But now when I want to manage decimals with #,##0.00 or 0.00 only, then the generated format is in custom (this is not a problem but it is putting the format

#,###.00 ... which gives me ".80" for the value 0.80 ...

I do not know why it does not config the format with the 0 ... is it a know issue ?

Thanks