Quarter value of forecast for the Qtr in which switchover occurs

hendersonmj
hendersonmj
in Modeling

What are the alternative workarounds for this?
When getting data from a line item Forecast version for a Quarter in which switchover occurs during the quarter, the QUARTERVALUE or [Lookup: <quarter>] return a value that only includes the Actuals amount for the month before the switchover date.  (see screenshot)

Tagged:

Answers

  • rob_marshall
    rob_marshall

    @hendersonmj 

     

    Try turning switchover off for the line item.  Also, Quartervalue()  will perform better than the lookup.

  • Aaron325
    Aaron325

    I have faced the same issue. Can anyone help me? 

    greatpeople me kroger schedule

  • Aaron325
    Aaron325

    I have faced the same issue. Can anyone help me?

  • Anren
    Anren

    Read the answer higher.

  • ManjunathKN
    ManjunathKN

    Hi @hendersonmj 

     

    Since your Switchover Month is Aug, until july it is actuals and from Aug it is rolling forecast. your total value for Quarter will be only 7 i.e, july. And if you go to Sept it will be july+Aug. so when you do lookup you will only get the Actuals quarter value. 

     

    you can use quartervalue for months after switchover with some if else formula. Else you can simply bring  Quartervalue formula across. Quartervalue bring the quarter total into months.

     

    Thanks,
    Manjunath

Categories