Months Spread

Options
jngo
jngo Member, ALL USERS, Partner, Certified Model Builder Posts: 1 New Contributor
in Planning & Modeling

Hi,

I am trying to figure out why my mothly cost will not populate based on the formula I provided. The goal is to show the monthly cost for only a certain time range and for the cost to not populate in the months it doesn't apply to. My issue is the cost will not populate at all.

 

Attached are screenshots of my formula and the issue.

 

Thanks!

Tagged:

Comments

  • Surya.Arif
    Surya.Arif Member, ALL USERS Posts: 5 Contributor

    Hi,

    From your first picture the "Blueprint" 

    We can see that "Monthly Cost - Dynamic" had a different time scale if compare to the rest of the line item.

    The time scale in that line is "Month" compare to other line items which is "Not applicable"

    Is it on purpose ?

    Because if the dimension is different, even a simple formula can act different than we expected.

    Is it on purpose or you rather add it later ?

    If you add it later then you should add the time scale to all of the line items including the header.

    if it is on purpose than you should use different approach in the formula.

     

    Hope this help

     

    SA

     

     

     

Categories