Variable line Item.

Ni363646

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

PaulRitner

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!