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.
Download the QV Cookbook from
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())