Get the Variance of Actual and Budgeted values for Dynamically for Departments in FRS
Hi,
I'm in the requirement of getting the Actual, Budgeted and Variance columns in Income statement. However the report should be able to run for the multiple departments. I tried to achieve this using a prompt for the Department value in FRS.
When run the report for a single department, it shows the actual and budget values and variance as expected as below.
the grid for the above output designed as follows.
However, i was unable to get the variance column correctly when it was run for the multiple departments. The expected output that i need to get is as follows.
Tagged:
0