0 value errors in calculation

[mickeyfinn]

I have the following calculation to express a percentage in a cross-tab report:

GetSummary ( Crosstab value Summary ; Breakfield ) / GetSummary ( Total values Summary ; Breakfield )

I have had to use a calculation to express the summary because using a fraction summary field does not work when the numerator of the fraction is a crosstab result and the denominator is a subtotal (unless someone here knows better).

The problem is that often the Total Values Summary will equal 0 when sorted by the Breakfield and this gives me a calc error (I get a ? result). I did this to solve the problem:

Case ( GetSummary ( Total Values Summary ; Customer ) ≠ 0 or "" ; GetSummary ( Crosstab value Summary ; Breakfield ) / GetSummary ( Total Values Summary ; Breakfield ) ; 0 )

Is there a better way to achieve this?