One Field Being Greater than the Other

[ajaydhamrait]

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!

[binu_acs]

@ajaydhamrait  one of the way of doing this

[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.