Show net amount in chart

[#1]

I am currently using this formula:

num(SUM ([JOURNAL DR])-SUM ([JOURNAL CR]), '$#,##0')

What I am trying to accomplish, is showing the actual solution to the above equation in the the "Window Tile" or "Show tile in chart" as a $ figure or in the "Window Tile". I am currently using a pie chart but the equation is showing in the window tile. I would like for the actual net amount to show.

Thank you,

Manny

[sinanozdemir]

Maybe try the below:

num(SUM (Total [JOURNAL DR])-SUM (Total [JOURNAL CR]), '$#,##0')

[Anonymous]

Did you put an equals sign before it, as in :

     =num(SUM ([JOURNAL DR])-SUM ([JOURNAL CR]), '$#,##0')

[#4]

Thanks  for the help Sinan. That did the trick along with the "=".

[#5]

Thanks for your assistance Bill.

[jduenyas]

Yeah

Always put an "=" sign to show value in an area that is designated for text.

you van also combine text and numbers like so:

='enter some text  ' & sum(your formula)

(Note that in this case you should not repeat the "=" sign before the function Sum() )