Subtotals and number patterns

[#1]

I people

I have a problem with subtotals:

I have a column with positive number and negative numbers. However, I don't want to have the minus signal '-' back to negative numbers. For that, I go to the 'Number' tab and get out the minus signal from the pattern and I don't have the minus signal anymore.

The big problem is I want the minus signal if the subtotal is negative... How can I do that??

Thanks in advance.

Best regards,

TMF

[rwunderlich · Accepted solution]

Download the QV Cookbook from

http://robwunderlich.com/downloads/

unzip it and look at the example "Alternate format for chart Total rows.".

The example shows how to use a money format in subtotals by doing the formatting in the epression:

=if(rowno()=0 or isNull(rowno())

          ,money(Sum(Sales),'$#,##0;($#,##0)')

          ,num(Sum(Sales),'#,##0')

)

-Rob