About formula

Options
kavitha12345
kavitha12345 Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

Hi 

i am trying to write the formulas about Actual/ Forecast

here i have actuals data and forecast data and current month selection

i am trying to write here 

IF ITEM(MONTH) < = Current month Then Actuals else Forecast

here i havve everything like I HAVE MONTH LIST AND CURRENT MONTH MODULE  Actuals data and Forecast data..

 

Thanks

Kavitha

 

 

 

 

Tagged:

Comments

  • kavitha12345
    kavitha12345 Member, ALL USERS Posts: 5 Occasional Contributor

    Thanks it resolved..

    here i am using Custom time scale..

  • kavitha12345
    kavitha12345 Member, ALL USERS Posts: 5 Occasional Contributor
    As per my client business they want time scale as split week level..so its not possible in Native Time ..

Categories