One Field Being Greater than the Other

Hi All,

I am trying to highlight the Excel Output Yellow if one of the fields (Inception Year) is higher than the other field (Vintage year). Is this possible?

For example, if Inception year is 100 and Vintage year is 90, I want it to highlight the Vintage Year Data point Yellow on the Excel Output.

Thanks!

Workflow

Output

Tips and Tricks

Help

Expression

Accepted answers

All comments

binu_acs

@ajaydhamrait one of the way of doing this

Color_10_05.yxmd

ajaydhamrait

Hi @binu_acs , I get the following error message:

flying008

Hi,@ajaydhamrait

you need defined a field name for formula, either select exist column or create new column.

ajaydhamrait

Hi @flying008 , both field names exist within my input data

flying008

@ajaydhamrait

yep, so you need put the formula output in a exist or new column.

binu_acs

@ajaydhamrait @Seems to be you did not give any field name , you need to give a name for this field

ajaydhamrait

@binu_acs still getting this:

binu_acs

@ajaydhamraitplease check you have field [Vintage Year] exist and it has the numeric data type. It the data type is string you need to either use toNumber([Vintage Year] or change the data type to double

flying008

@ajaydhamrait

the error-popup show your field type at least one is not a number, so you need to use toNumber() function in expression to rebuild it.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703