Skip to main content

Hello to the community,

 

I am using GL balance data set to create reports on Business Reporter; All credit values, revenues are shown as negative amounts and costs have positive values; I was wondering if I could switch this value format presentation somewhere in order to show cost with minus sign (-100) and revenues as positive amounts? 

 

Thank you for your help :) 

 

Tanya

@MelTanyaS what if you apply a formula on the excel cell to multiply with -1? This would revert all the amounts.


Hello, thank you for your reply.

 

I tried creating a standard parameter called balanceparameter, then used it in a function parameter

It could work that way, but i’m looking for a way to apply it to all balance in the report without having to set a parameter value like shown below + hard to select all balances from the list to apply parameter to.

 

Is there according to you a quicker way to apply it to all balances without having to use a parameter like this one or without having to run a formula everytime we load a report to get the result of multiplication? 

 

Thank you

Tanya


Hello again, 

 

Just found the solution to reverse the value signs in the “options” tab

 

Thank you again

Tanya


@MelTanyaS  wasn’t aware about this option. Thanks for sharing 😀


Reply