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... etc but would also like to know what other formatting options are available as well.

 

Currently my output is the below and I am trying to make the 'math.Round(Acc1,2)' part easier to read.

 

Does anyone know of a resource that lists the different formatting options? 

Or just how to add the comma seperators?

 

Thanks

Simon

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 🙂

3 Replies

  • Koemets's avatar
    Koemets
    Contributor
    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 🙂

    • SimonEx's avatar
      SimonEx
      New Contributor
      3 years ago

      Thanks that is exactly what I was after.

      No more counting zeros 😀

  • 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