topic Cell Value Comparision in App Development

Cell Value Comparision

nitin_01 — Tue, 08 Jan 2019 12:18:49 GMT

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.

Re: Cell Value Comparision

sunny_talwar — Tue, 08 Jan 2019 12:35:34 GMT

So, based on your image above... which rows will display 1 and which ones will display 0?

Re: Cell Value Comparision

nitin_01 — Tue, 08 Jan 2019 12:45:13 GMT

Hey Sunny nice to hear from you after long time.

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.

Re: Cell Value Comparision

nitin_01 — Tue, 08 Jan 2019 12:46:22 GMT

1st ,3rd,4th,7th,10th,13th . These will be set as 1 and rest 0. As per logic.

Re: Cell Value Comparision

nitin_01 — Fri, 11 Jan 2019 13:18:14 GMT

Please update.