Hello Everyone,

I'm wondering how to calculate a variance in a report, which would calculate the variance from the subtotal based on one of two choices in another field.

For example, I created a field which holds the type of amount (income or expense) and I have a separate field for the amount and I have a subtotal calculated in the report for each type (income & expense). How can I calculate in a separate field what the variance is between the two amounts (income & Expense)?

Thanks,

Monika

Did you try the Variance function?

I have a feeling this is a misnomer (there is no such thing as "variance between two amounts") and that the question is really about the DIFFERENCE between two sub-summary values. If so, the answer is a calculation field =

GetSummary ( sTotalIncome ; breakField ) - GetSummary ( sTotalExpense ; breakField )