Variable line Item.

Hi All,

 

I have a Situation where value needs to be changed after a period of month.

 

Time Value
17-Jan 10
17-Feb 10
17-Mar 10
17-Apr 15
17-May 15
17-Jun 15
17-Jul 22.5
17-Aug 22.5
17-Sep 22.5

 

Here value is changed after every quater only for a line item i.e increased by 50%.

 

Regards,

Nitika

Comments

  • Hi,

     

    I'm not sure I fully understand what you are trying to do, but if the use case is that "increase the value by 50% ever three months", then one way to do this is (pseudocode):  IF (the average of the prior three months)=last months value then (last months value * 1.5) else (last months value). 

     

    Note that you would need to seed/initialize the 1st month in the time range (or year, etc), so there might be another line item involved, and the formula might look more like one of the following: 

     

    IF (last months value)=0 then Seed Value else IF (the average of the prior three months)=last months value then (last months value * 1.5) else (last months value)

     

    or

     

    If (Seed Value <>0) then Seed Value Else IF (the average of the prior three months)=last months value then (last months value * 1.5) else (last months value)

     

    Let me know if this helps!