Result based on Derived value.

[ajaykumar1]

Hi All,

I want to show the expression 3 result based on the exp1 and exp2(Not their on the original values.)

Here am attached the sample application.

[jyothish8807]

I guess its working fine. What's the issue?

Regards

KC

[ajaykumar1]

Thanks Jyothish,

Let me explain from above:

Exp1-----3%    <=  exp2---3%  so column3  "First"------------------Fine

Exp1-----3%    <=  exp2---3%  so column3  "Second"-----------------wrong(Because getting result based on the 2.96  <= 2.9 .I want result based on after percentage like 3%   <=  3%..So it shoulb "First"

Exp1-----8%    <=   exp2---3%   so column3   "Second"------------------Fine(This result also like above explanation)

I hope its clear again.

More Thanks,

Ajay

[jyothish8807]

It is not wrong, go to numbers and change it to fixed 3 then you can see the numbers are fine.

In second case column 1 is 3.96% and Column 2 is 3.90%. So your output is fine. Hope it will help.

Regards

KC

[ajaykumar1]

Your Right...If am did fixed to 3 then i will get result.

But in the real data around 10 digits are there and they keep integer and show in percentage option

So on the percentage result only i have to derive 3 expression.

More Thanks,

Ajay

[morganaaron · Accepted solution]

If you want it accurate to 1% (as in 0.01) then use the round command, so for column 3 write:

if(Round(Column(1), 0.01) <= Round(Column(2), 0.01), 'First', 'Second')

[jyothish8807]

Hi,

Then as Aaron Mentioned, use round function. or num(Colum(1),'##')

Regards

KC