Comparison calculation for price variation check

[RAJ6]

Hi Talend Folks,

Check the Yesterday Price with Today Price. if today's price is more than 5% of Yesterdays Price then i need to set below values

"Not Ok" else "Ok'

How to write query for above scenario.

I tried but i don't know logic is correct or wrong. could please tell me ?

row1. Today_Price  >(row1. Yesterday_Price *0.05)? "Not OK" : "OK"

[Anonymous]

The expression looks OK to me. Have you tried it? The only thing I can think that could cause problems is if either "Today_Price" or "Yesterday_Price" is null

[cterenzi]

Are you sure the requirement is to check if the price is more than 5% of yesterday's price and not a change of more than 5%?

[RAJ6]

Ya Sure.