I am facing a problem, can someone solve it, please.
I have a module which has Employee, Time Range(FY01 to FY15) as Dimensions
Line Item - IP(List format), Growth % (Number Format)
IP Line item is user input, by selecting a list item from a dropdown.
Growth % - Value(Name(IP)) - Will change to number format.
Let's assume that the user enters the value in the IP Line item for an employee from FY01 to FY04. as a result Growth % is also calculated from FY01 to FY04
My objective is when a user enters (LAST ENTER) the value in the IP Line item for an employee in FY05.
That particular value should be copied to till the end(FY15).
Likewise when a user enters the value in the IP Line item for an employee in FY06.
That value should be copied to till the end(FY15).
Emp-1 IP Growth %
FY01 2 2%
FY02 4 4%
FY03 5 5%
FY04 3 3%
FY05 5 5% -----> Last Entered
FY06 5 5%
FY07 5 5%
FY08 5 5%
Go to Solution.
Use the "Previous" function to get this, see the screenshot below.
I would add some conditions to @VIGNESH.M 's solution.
Assume your FY is represented as Month in my suggestion below.
THANKS VIGNESH, IT WORKS. 🙂