Thank you Nilesh and Sreenivas for your quick reply!
But I would like to add:
Suppose I do not want to create a new variable and I just want use the old variable Variable1 (it shows the calculated monthly score for current month aka August)
Is there a way where i can write an equation of the form:
Equation: call Variable 1 for condition Monthname(max(MonthName)-1)
Note: Monthname(max(MonthName)-1) condition must be used
So July value field would be =__________(equation)_____________________ and it would display Variable1's particular value for July..
I am not too well versed in code so you guys are being really helpful!