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 🙂

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 ðŸ˜€