New Contributor

## 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

Valued Contributor

## Re: Variable line Item.

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!