hi all! i'm not sure where to post this. i hope i'm posting at the right section.
previously i use formula as below;
Dim total1 As Label = CType(e.Item.FindControl("total1"), Label) total1.Text = e.Item.DataItem("receivable").ToString * 365 / e.Item.DataItem("revenue").ToString
note that the 'receivable' and 'revenue' are taken from database(mysql)
however,if the formula of a calculation involve data for current year divide by data from previous year, how should i implement it? for example;
revenue from current year * 365 / revenue from previous year