topic Re: Finance Report in Report Server

Finance Report

netanel — Wed, 27 Nov 2019 13:17:25 GMT

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 all the solutions I didn't find anything to fix it .

Re: Finance Report

MaxNovak — Wed, 27 Nov 2019 13:49:34 GMT

Hi,
I'm not completely sure about the question. If I understand you correctly you
want to format the Amount, if it is negative to put Amount into brackets.

If this is correct just make a measure like this :

FORMAT(Amount,"#,###0;(#,###0)")

Re: Finance Report

netanel — Thu, 28 Nov 2019 13:41:20 GMT

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

Re: Finance Report

MaxNovak — Thu, 28 Nov 2019 15:47:50 GMT

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)")

Re: Finance Report

netanel — Sun, 01 Dec 2019 06:20:57 GMT

Many thanks for the time and greatly appreciate it