Formula for a Line Item

Options
LorraineGSD
LorraineGSD Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor
in Planning & Modeling

Hi All, I'm having trouble figuring out the formula for this. I need to create a Formula for "A" for the succeeding months but the first month should be an input.

LorraineGSD_0-1628151482094.png

Thanks!

Tagged:

Comments

  • naveenmaurya
    naveenmaurya Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Lorraine,

    You cannot have both input and formula for the same line item.
    What you can do is to create a new line item let's say "A1", where you will take value as input

     

    naveenmaurya_1-1628159560712.png


    Also create a Time Settings Module which has time as dimension and one boolean line item First Month? which will look like this

    naveenmaurya_0-1628159400231.png

    After this use formula in line item "A" of your module 

    IF Time Settings Module.'First Month?' THEN 'A1' ELSE PREVIOUS(A) - PREVIOUS(B)

    I hope this helps.

     

     

Categories