Calculating % variation

[vittorio]

I have wrapped to years some calculated values, put the years in columns, and would like to add programmatically a column to the right of each year with the % variation calculated on the value of the previous year.

Is it possible? How?
Thanks

[AlexZencovich]

You may do it as calc. measure over variation (ctVariation) measure. You need only check which year you will take as base.
Most easy way - take calc. measure like

Result = 100 * (Sum[Value] - Sum[PREV_BY_ROW])/Sum[Value];

[vittorio]

HI,
tried to do as per your post but

- didn't find ctVariation but only ctVariance (don't think it is the same measure)

- Result = 100 * (Sum[Value] - Sum[PREV_BY_ROW])/Sum[Value] as a calculated measure over my measure gives an error but I can't understand why

[vittorio]

it would be great a complete sample code in VB2005 - I didn't find anything that helps in the help file
thanks

[AlexZencovich]

1. I do not provide development in VB2005. Sorry.
2. I also could not understand why because your formula works fine with demo examples