Budget values default to Actuals when I add Unit Set to Report Definitions

Hello @jwarren ,

Ledger may be added to a report using Data Source screen in the Row Set, Column Set, Unit Set, or Report Definition. Based on your description of your problem, it seems like the Data Source may be defined in both the Column Set and again in the Unit Set and the settings may be different, conflicting with each other.

1. Make a copy of your Unit Set, in case it is used successfully in other reports.
2. In the new copy of your Unit Set, remove the Ledger from all 3 levels of your Unit Set: from All, DIST, and from MANU:

3. 

   Leave Ledger blank on Row Set’s Data Source.

4. Leave Ledger blank on Report Definitions screen.

5. 

    

6. Connect the revised Unit Set from step 2 to your Report Definition and verify if the problem is solved.

Ledger does not typically need to be on the Unit Set or the Row Set but is normally added to the Column Set for a report that is showing Actual versus Budget in separate columns. Good luck!

Laura