reversing a number

[#1]

hi,

i'm struggling to reverse the output here without ant success. would appreciate if someone helps

=num(sum({$<Dist_Date={"$(=Date(AddMonths(Max(Dist_Date), -1), 'MMM-YYYY'))"}>}[Gross Sales])/1000000,'#,###M')

[sunny_talwar]

What do you mean when you say reverse the output?

[#3]

Hi,

I just needed the output of the above expression on the negative axis despite a positive number. I completed it by multiplying the expression by -1.

Thanks anyway

[swuehl]

Maybe just multiply by a Million and format as you like, without the postfix?

=Num( Num( 123456 / 1000000 ,'#,###M')*1000000,'#,##0')

edit: this expression using two num() obviously doesn't make sense, it should just show the principle