Forum Discussion

netanel's avatar
netanel
Post Prodigy
6 years ago
Solved

Finance Report

Hello everyone, I have one Amount column and it brings me all the numbers to the reports, the problem is that the numbers come in minus 500 instead of (500). I know this is a common problem but in ...
Report
  • MaxNovak's avatar
    MaxNovak
    6 years ago

    Great, then we are halfway to the answer 🙂
    It probably doesn't work because you are putting a column in the place of a Measure. 
    I think you should make a measure as Total Amount = SUM(Amount), and then use that measure in this Formating. 

     

    Measure = FORMAT(Total Amount,"#,###0;(#,###0)")

    or you can make this all in one measure with a variable :
    Measure =
    var Total Amount = SUM(Amount)
    return FORMAT(Total Amount,"#,###0;(#,###0)")

netanel's avatar
netanel
Post Prodigy
6 years ago

You got me right, but it's a solution I've already tried and it doesn't work for me, this is the message I get

 

 

MaxNovak's avatar
MaxNovak
Resolver I
6 years ago

Great, then we are halfway to the answer 🙂
It probably doesn't work because you are putting a column in the place of a Measure. 
I think you should make a measure as Total Amount = SUM(Amount), and then use that measure in this Formating. 

 

Measure = FORMAT(Total Amount,"#,###0;(#,###0)")

or you can make this all in one measure with a variable :
Measure =
var Total Amount = SUM(Amount)
return FORMAT(Total Amount,"#,###0;(#,###0)")

  • netanel's avatar
    netanel
    Post Prodigy
    6 years ago

    Many thanks for the time and greatly appreciate it