Amount and Pct variance confirmation rules for all base accounts

Hi,

The first thing that comes to mind is that you are checking data in EUR and hard-coded the threshold like this: "10000.00". If the user culture of the user executing this is in US format, this means ten thousand as the decimal point is a period sign. Since you are using EUR, and in many countries using the EUR, the period sign is a thousand separator and a comma (,) is a decimal point, the above code will not work properly if not all users are using an US based user culture to format their numbers.

Here is an explanation on the Microsoft homepage with some more information:

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

This might help getting the number format right:

Solved: Format output of confirmation rule - OneStream Community (onestreamsoftware.com)

Here is a post with a simple example on how to loop through accounts and add all 'fail' accounts to the information box:

Confirmation Rule help - OneStream Community (onestreamsoftware.com)

And for a lot more information and examples, please refer to this in addition to the general documentation that is available (the presentation is quite old, but should still work mostly fine):

Question: Is it possible to loop through members within confirmation rules? - OneStream Community (o...

And one additional note is that using the "/" to divide data will error out when the divisor is zero. Using the divide function will not error out and is generally recommended to be used. You can find a quick example here:

Net Profit Percent - OneStream Community (onestreamsoftware.com)