The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

SimonEx's avatar
SimonEx
New Contributor
3 years ago
Solved

Format output of confirmation rule

Hi I am getting some large numbers out of my confirmation rules and I am looking for ways to format the output so it is easier to read. Preferably commas between the thousands, millions, billions.....
Confirmation Rules
  • Koemets's avatar
    Koemets
    3 years ago

    I think what are you looking for is this:

    "A#MCF0015050_PLG = " & Acc1.ToString("#,###.00")

    Here is the decent read on formatting:

    https://www.thevbprogrammer.com/VB2010_04/04-01-FormattingNumbersDateStrings.htm

    It's written infinitely better than Microsoft Learn article on formatting 🙂

Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
3 years ago

Hi, this returns the string depending on the culture settings of the individual user. 

XXX.ToString(cultureInfo.InvariantCulture))

Here is some information on culture and strings:

https://learn.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/strings/how-culture-affects-strings