Hi All,

I have to do the difference of two fields, which is quite easy in itself. However, one of those fields is a formula.

The reason for the formula is NULL values are entered by the software if nothing is entered into that field. I altered the report to add a formula field as below.


if isnull({RptHRPOSN_PositionDifference.Position_Budget}) then 0.00 else {RptHRPOSN_PositionDifference.Position_Budget}

This formula allows for the 0.00 value to appear if NULL is in the table.

Now I want to do the difference of this field and another which is ({RptHRPOSN_PositionDifference.Wage_Allocated}).

However, creating the difference of the two gives me the error "A formula cannot refer to itself, either directly or indirectly"

Thanks for your help.

you can also just set the formula field to 'use default values for nulls' then subtract them without using anther formula field

Supposedly, if the default value for Nulls is zero for numeric fields, then DBlank's idea should work.  I cannot remember if I have tried that anytime recently.