There is a scenario where I need to calculate a rate effect for which logic is,
(CurrentPrice-BasePrice)>=1 wherever I get this rate effect as 1 that should be seen in UI. Current Price comes from URL.
In shared excel my BasePrice comes from first date from field Date i.e. Min(Date), after comparing this BasePrice with next Prices, wherever we get the next first rate effect as 1, that date Price will be my BasePrice and this Price will be compared to next Price and so on.
In UI need to show flag's with 1 and there date. Its okay if we remove data with flag 0.
Based on above image 1st ,3rd,4th,7th,10th,13th. Now this 13th Line item will be compared to Price coming from URL if again difference between Price is -1 or +1 then next base price would be the new compared price.