You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get the Variance of Actual and Budgeted values for Dynamically for Departments in FRS

edited Dec 9, 2024 7:47PM in Budgetary Control 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!