Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Regards,
Nitin G.