Report design - Custom negative currency format

[midspace]

How do we go about making a currency format that has a negative format of "$(n)" ?

The current currency formats don't support it, and the custom format field doesn't describe how to set up a positive and negative formats.

StimulsoftNegativeCurrencyFormat.png (95.08 KiB) Viewed 4084 times

[Lech Kulikowski]

Hello,

Sorry, we did not exactly understand your question. Could you explain your issue in more detail?

Thank you.

[midspace]

Hi, we need to use a negative currency format of "$(n)" in our reports.
The Stimulsoft designer appears to only have a small selection of fixed formats for the negative currency value, and does not include "$(n)". It does not allows us to specify our own either.

Looking at the Custom format option, there is only 1 field! There isn't a split positive, negative field options.
I was hoping for something like MS Excel, where we could somehow specific the formatting for negative values, but I cannot find any Stimulsoft documentation on if this can be down, nor how to do this.
Please help.

This is how MS Excel does it:
https://support.microsoft.com/en-au/off ... f18b4eae68

[Lech Kulikowski]

Hello,

You can use the Format() or ToString() options.

Thank you.