Home > Report Designer > Troubleshooting > Toggle Switch Sign

Toggle Switch Sign

When you generate a pre-defined layout, you will notice that certain fields in the row groupings have their signs switched, in particular, revenue accounts which are stored as negative values in the underlying data. It does not make sense to present these in a statement as negative figured which is why the sign is switched to a positive.

In the situation where you delete the primary row grouping and replace it with a new one of your choice, the Designer has no way of telling what fields you are going to include within the newly selected row primary row grouping, so by default the field’s sign status will be the same as that in the underlying data – for revenue accounts this will be negative values. You have the option to switch the sign of any of these fields that you include in the primary row grouping. You do this by right-clicking on the button of the field that you want to change the sign of...

And clicking on the Toggle Switch Sign popup. This will then switch the sign of this field from its default value in the underlying data. If it is negative, it will become positive, and vice versa.