1. Help Center
  2. Report
  3. Learn More About Reports

Report FAQ: Assumption is not displayed in Actuals

Learn how to correctly present Custom data under Reports

Question:
I have a Line in a Custom Table that is calculated using a Global Driver based on the Assumption. When I am viewing the Custom Table in Plans, I can see the calculated values in Actuals. However, when I go to the Report and place the Custom Line in a Report displaying Actuals, it is blank. How do I fix this? 

Report:

Custom Table:

Answer:

This behavior typically occurs when an Assumption is used in an Actuals period. Assumptions as represent key variables for your company and concert Forecasts in their nature.

If you are using a Global Driver in an Actuals period which is based on the Key Assumption, change it to be based on the Constant value:


Remember to adjust the Cutover Date to the Min Date from More Options. This will allow you to see both Actuals & Plans for the presented Custom Line in reports.


Alternatively, you can import Actual Churn % from Google Sheets or Excel.
Before importing Actuals from Google Sheets, you must first configure the lines within a Custom Table (check an "Allow Import") and click on the Export New Lines to G Sheet button


Go to Settings⚙️> Actuals > Google Sheets > Connected Sheets and populate Churn % under right Custom Lines and months:



Now, go back to Jirav > Settings⚙️> Actuals > Import Your Data > Google Sheets > Import:

Learn more