i created a report that displays budget report for a certain year. This report computes the rate of the variance of the current budget compared to the last year's actual amount. I assigned this to a variable with this formula:
(Current year's budget - last year's actual amount) / last year's actual amount
Current year's budget = sum of all current budget amounts of each account code of the said group (variable)
last year's actual amount = sum of all last year's actual amounts of each account code of the said group
This formula works with groups having 2 or more records, but this formula returns null when the group has only one record.
the pdf attachment will describe my issue. The rows with green fill are the group footers. the column i am having issue is the % column of the Other Income group wherein it only has one record. Other groups with 2 or more records has percentage value, but this particular group with one record has a null percentage value...