Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
did you see the "Market Value:"?
if not check in number tab the number format is set to expression default
did you see the "Market Value:"?
if not check in number tab the number format is set to expression default
I've been wracking my brain for an hour over this! Setting number format to Expression Default solved it. Thanks!