Divide By rows in the same column

[pgalvezt]

Hello,

I need to calcule row 2 / row1 same column

My Formula is Num(sum({<Day_Date=>}if(Data_Date >= A_date and Data_Date <= AB_date, Ray)),'#.##0,00')

How to get the final result with that formula,

I attached an excel example for better comprehenssion,

Thanks!!

[kaushiknsolanki]

Hi,

You should try to load the data in descending order and then use previous function to find the previous record.

Something like this.

Load *,Previous/Current as NewField From xyx order by date desc;

Regards,

Kaushik Solanki