Formula error

Options
AlexForsythe
AlexForsythe Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

My formula is not working. Here is what I have:

 

IF 'Sales Trend V4'.'2019A' = Gross Sales.'2019A' THEN 'Sales Trend V4'.'2019A'[SELECT: GL Name Sales.Sales] / 'Sales Trend V4'.'2019A'[SELECT: GL Name Sales.Cases] ELSE IF 'Sales Trend V4'.'2020A' = Gross Sales.'2020A' THEN 'Sales Trend V4'.'2020A'[SELECT: GL Name Sales.Sales] / 'Sales Trend V4'.'2020A'[SELECT: GL Name Sales.Cases]

 

I'm trying to divide 2019A sales by 2019A Cases THEN 2020A Sales by 2020A Cases.

 

 

 

 

Tagged:

Comments

  • AlexForsythe
    AlexForsythe Member, ALL USERS Posts: 5 New Contributor

    Here is the blueprint for the Sales Trend V4

    AlexForsythe_0-1622213621646.png

    Here is the blueprint for the module that I'm trying to do the calculation in

    AlexForsythe_1-1622213701991.png

     

  • AlexForsythe
    AlexForsythe Member, ALL USERS Posts: 5 New Contributor

    Because our fiscal calendar does not line up with the normal calendar.  

Categories