Business reporter value format - show revenues as positive values on BR
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
Page 1 / 1
@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