Hello,
I have an independent field on a parent form, and in this field I added the following expression in expression builder in order to display the total of a subform
Code:
= TrueFalse (IsNumeric ([EntrySalesDetails]. [Form]! [TxtBigTotal] - [SaleDiscount]); [EntrySalesDetails]. [Form]! [TxtBigTotal] - [SaleDiscount]; 0)
However, it only works when there is at least one row of data in the subform. But when there is no row I get a #Type! error
Please can someone help me display 0 when there is no row of data ??