topic Re: Comparing two columns in table in App Development

Comparing two columns in table

aswinnar — Mon, 20 Dec 2021 21:08:46 GMT

I'm having a requirement where I need to compare two columns within a table:

I am needing to provide a visual cue such as a a different background color for 'A' if the date for that field is earlier or later than 'B'.

I'm using the following expression:

if(Field1 = 'A', if(Date > Below(Date),Green(),Red()))

however the background color only showing red for me when it should be showing as green

Is there something that I am doing wrong?

Kushal_Chawda — Thu, 27 Aug 2020 22:56:34 GMT

try below

if(Field1 = 'A', if(Date > Below(total Date),Green(),Red()))

aswinnar — Fri, 28 Aug 2020 03:03:43 GMT

Yes, that worked. Thanks!

I had forgotten to mention that the they were also wanting grey color if the dates are the same.

What would the expression be?

PrashantSangle — Fri, 28 Aug 2020 15:37:37 GMT

add one more if in it try below

if(Field1 = 'A', if(Date > Below(total Date),Green(),if(Date<Below(total Date),Red(),grey())))

Regards,

aswinnar — Fri, 28 Aug 2020 19:28:18 GMT

Hi I tried that, seems that I am still seeing the text turn green when the dates are the same