Forum Discussion
Calculating previous row with earlier function
Hello, I have the date, user, value columns. In a date, I can have many users and the value for each user should grow. I need to know when a value is smaller for a later date. I cannot use index...
Hi Anonymous ,
No problem. Here you go
You just need to change the variables _curr and _rank and it will work fine.var _curr = MinVal[Value]var _rank = MinVal[Rank]Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
NickolajJessen
Solution Sage
Solution SageThis here grants you the lowest future value
Then you can add conditionaly formatting for whatever you are looking to do with it 🙂