Positive and Negative #s in Block Chart

[jdmarlin]

I've created a block chart where the block size is calculated with the following expression: Fabs(Sum({$<Date={'$(=vMaxDate)'}>} Value)

I'm trying to use the Dual function so that when you hover over a block a positive or negative number will appear:

Dual('Market Value: ' & Num(Sum({$<Date={'$(=vMaxDate)'}>} Value),'##,###.00'), Fabs(Sum({$<Date={'$(=vMaxDate)'}>} Value)))

But a negative number still appears as a positive number when I hover over a block.

I've used this formula before in other QV apps, but for some reason it doesn't appear to be working in this one.

Thanks for any help!

[maxgro · Accepted solution]

did you see the "Market Value:"?

if not check in number tab the number format is set to expression default

[jdmarlin]

I've been wracking my brain for an hour over this! Setting number format to Expression Default solved it. Thanks!