OneStream Community

SteveK

If you encounter an Amount field that has spaces as the thousands separator AND includes a DR/CR indicator (e.g. 12 345 678 D) then you'll need this to parse the value: Dim strRawAmount As String = api.Parser.DelimitedParsedValues(4) ' Zero-based and...

SteveK

BRApi.Utilities.EncryptText isn't encryption though - it's a BASE64 encode......

SteveK

Good point on the multi-culture element from the XFxxxx equivalents of Replace etc. in VB.NET.In this case I didn't need it, but I'll add in to V2.0!

SteveK

It's indeed a Parser Rule, so you can use it as a Complex Expression for the Amount field in a Data Source - or you could put it in a Business Rule for re-use if you have multiple Data Sources that need to do the same thing.

OneStream Community

User Statistics

User Activity

How to deal with an Amount Field that has space as a thousands separator AND a DR/CR indicator!

Re: Best Practice to Store Encryption Key Passphrases and Passwords in OneStream

Re: How to deal with an Amount Field that has space as a thousands separator AND a DR/CR indicator!

Re: How to deal with an Amount Field that has space as a thousands separator AND a DR/CR indicator!