topic Re: Division with SUBTRACT inside in App Development

Division with SUBTRACT inside

Anonymous — Sun, 04 Feb 2018 13:25:05 GMT

Hello everyone,

i have a simple division to do, i need

X / Y

where:

X = ( Expression A - Expression B )

Y = (Expression C + Expression D + Expression E)

please help

thanks in advance

Re: Division with SUBTRACT inside

Anonymous — Sun, 04 Feb 2018 20:14:53 GMT

Would simply doing this suffice :

( Expression A - Expression B ) / (Expression C + Expression D + Expression E)

Re: Division with SUBTRACT inside

Anonymous — Mon, 05 Feb 2018 05:24:58 GMT

i figured that in the beginning but it didn't work.

it gave me a wrong number.

( Expression A - Expression B) = 95,507,436

(Expression C + Expression D + Expression E) = 5,995,249

the division must be = 0.062

but it gives me 95,507,434

i'm not sure why..

Re: Division with SUBTRACT inside

Anonymous — Mon, 05 Feb 2018 17:34:05 GMT

That is strange.... could you share the full expression that gives you the 95,507,434 figure plus any other expressions it relies on.

One thing I notice is that 95,507,436 / 5,995,249 will be greater than 1, whereas you want 0.062 which is less than 1 and could well be the result of 5,995,249 / 95,507,436. I.e. things may be upside down.

Quite how you end up with 95,507,434 is a mystery to me. If you post a sample qvf with sample data that would be great.