Skip to main content
Solved

ARM Visibility formula needed for 12 month rolling forecast report

  • October 7, 2024
  • 2 replies
  • 120 views

I am working on a 12-month calendar forecast P&L.  It is not a rolling report and will always display January - December from left to right and a total. The results will display either actual or budget.  For the months up to and including the date the report is run the actual results display by month and budget will display for the months after the date selected.  For example, if I set the date to 08/2024 the report will display actual results in separate columns for January - August and budget in the columns for September - December.along with a total.  The column set has 36 columns, 12 columns to pull actual, 12 to pull the budget and 12 to add the combination of actual/budget based on the date selected.  I have it working to display either actual or budget by month using a visibility formula.  I now need the visibility formula to use in the 12 columns of totals so that only the total for the combination I have selected displays.  I have tried the formulas in other discussions, and they do not work for this set up.

Best answer by nhatnghetinh

Hi @jweber 

Please refer to the screenshots and attached xml file.

 

 

Best Regards,

NNT

View original
Did this topic help you find an answer to your question?

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • October 7, 2024

Hello @jweber ,

The visibility formula on your Total columns will look something like this:

Period 01:   =IIf( Left(@EndPeriod,2) =1, true, false)

Period 02:   =IIf( Left(@EndPeriod,2) =2, true, false)

Period 03:   =IIf( Left(@EndPeriod,2) =3, true, false)

 

Laura


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 531 replies
  • Answer
  • October 8, 2024

Hi @jweber 

Please refer to the screenshots and attached xml file.

 

 

Best Regards,

NNT


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings