## Previous function in a if then statement

Occasional Contributor

## Previous function in a if then statement

Hey there,

I am trying to figure out the calc logic where the user has the ability to input a percentage in which will then be applied/reduce to the number. However i need a logic statement where the reduction is applied from previous quarter to next quarter.  For example i have 100 in Q1Fy19 and then will have 99 in Q2 Fy19 98 in Q3 Fy19 and so forth.  I know I have to use the PREVIOUS function but can't figure out the logic of how it is applied from the previous quarter to the next quarter.

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

## Re: Previous function in a if then statement

Is this what you are trying to achieve?

Regards,
Kavin.

Regards,
Kavin.
2 REPLIES 2
Certified Master Anaplanner

## Re: Previous function in a if then statement

Is this what you are trying to achieve?

Regards,
Kavin.

Regards,
Kavin.
Occasional Contributor

## Re: Previous function in a if then statement

yes! Thank you I appreciate this!