Custom Calculation

Hi all,

Let’s say I have a report with four variables v1 throug v4. The data for this variables presented for three months - 5/04,6/04,7/04. Is it possible to create the following %-change calculation:

(v1(7/04) - v1(6/04))/v1(6/04)

Thank you!

:crazy_face:


xta777 :us: (BOB member since 2004-06-23)

You can use the Previous() function to accomplish this.

=( - Previous() )/ Previous()


digpen :us: (BOB member since 2002-08-15)

digphen, thank you for the tip!


xta777 :us: (BOB member since 2004-06-23)