Page 1 of 1
Report design - Custom negative currency format
Posted: Wed Jun 19, 2024 2:51 am
by 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 4087 times
Re: Report design - Custom negative currency format
Posted: Wed Jun 19, 2024 7:09 am
by Lech Kulikowski
Hello,
Sorry, we did not exactly understand your question. Could you explain your issue in more detail?
Thank you.
Re: Report design - Custom negative currency format
Posted: Fri Jun 21, 2024 12:00 am
by 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
Re: Report design - Custom negative currency format
Posted: Fri Jun 21, 2024 9:32 am
by Lech Kulikowski
Hello,
You can use the Format() or ToString() options.
Thank you.