| Category: | Bug report |
Priority: | Normal |
Status: | Assigned |
| Project: | Severity: | Major |
Resolution: | Open |
|
| Component: | Reproducibility: | Always |
Assigned to: |
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
where:
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.
| Attachment | Size |
|---|---|
 BudgetDetails_All_Dept.jrxml | 20.13 KB |
 BudgetDetails_All_Dept.pdf | 31.36 KB |
1 Comment:
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...