Does anyone know if I can in table expression to check whether some percentage value less then other in some field?
I have table with field Year,Minimal Realization % and Bonus Amount (LCY),(picture below), what I want is to check all values from field minimal realization and gave him bonus amount if calculated value is less than values in minimal realization.
If my calculated vlaue is 93%, I want to gave him 10.000,00 bonus