Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
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
I make simple example in QV.
I want in straight table in expression to check for example:
If 94% (Realization %) < 100% (Minimal Realization %) then he get 10.000 bonus
Is this possible to do in expression?
Hope someone can help me
Stefan,
assuming that bonus grows up when minimal realisation grows up, yu may define chart with:
dimension: EmployeeName
expression (one of):
a) max(if([Realization %]>[Minimal Realization %],[Bonus Amount]))
b) FirstSortedValue([Bonus Amount], if([Realization %]>[Minimal Realization %],-[Minimal Realization %]))
regards
Stefan,
assuming that bonus grows up when minimal realisation grows up, yu may define chart with:
dimension: EmployeeName
expression (one of):
a) max(if([Realization %]>[Minimal Realization %],[Bonus Amount]))
b) FirstSortedValue([Bonus Amount], if([Realization %]>[Minimal Realization %],-[Minimal Realization %]))
regards
You can use the intervalmatch function. See attached qvw.
Gysbert thanks for you quick reply.
It was helpfull, but my problem is I dont know Realization % in script, I calculate that in straight table expression, and there I want to check in what interval he belongs.
Is this posible at all?
You may find alternative approach also here:
Re: pick rating on the fly using calculated score
regards
Darek
Txn Dariusz,
Your answer is correct