Skip to main content
Question

Business reporter value format - show revenues as positive values on BR


Forum|alt.badge.img+7

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

4 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • February 19, 2024

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


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 99 replies
  • February 19, 2024

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


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 99 replies
  • February 19, 2024

Hello again, 

 

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

 

Thank you again

Tanya


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1142 replies
  • February 19, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings