Variable line Item.

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

Message 1 of 2
1 REPLY 1
Community Boss

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!

 

 

Message 2 of 2