Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

FormatNumber ?!

Hi,

When I use this formula:

=FormatNumber([Other Regions WI].[Netsalesaa];"###.###")

Result is:

######

Why?

If I use =FormatNumber([Other Regions WI].[Netsalesaa];"###_###")

Result is

###_###

Strange or am I missing something?

Former Member
Former Member replied

Try this

=Replace(FormatNumber(Other Regions WI.Netsalesaa;"###.###");",";".") you are first formatting the number and once the number is formatted with " , " present you use the replace function to replace " , " with " . "

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question