Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a dual label where it shows the text label and numeric price side by side with '-' between them.
For some reason its not showing correct? I can see is the Price but no DODAAC prefix.
I would like to be able to use this in other charts once I get it working. perhaps someone can emulate this with a similar data set?
Dual( DODAAC&'-'&Num(Sum([TOTAL_PRICE]),'#,##0') , Sum([TOTAL_PRICE]) )
See attached image
My problem was located on the number tab. The expression was set to Money once I changed it to Default the text portion showed. So even when an expression is correct all it takes is one simple setting to prevent proper usage.
My problem was located on the number tab. The expression was set to Money once I changed it to Default the text portion showed. So even when an expression is correct all it takes is one simple setting to prevent proper usage.