Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm trying to obtain a division of two numbers. Separately the numbers are 9820 and 21,3% I just need to multiplicate them. Calc shows 209,166
=(Round(Num(Sum(If(IDCode='39000' and Año=xAñoMax, Saldo))/Divisor)/Num(Sum(If(IDCode='19000' and Año=xAñoMax, Saldo))/Divisor)*100, 0.1 ) & '%')
*(Floor(Sum(If(IDCode='19000' and Año=xAñoMax, Saldo))/Divisor) - Floor(Sum(If(IDCode='19000' and Año=xAñoAnt, Saldo))/Divisor))
Gives 2091,66
Thanks!
I think you need a new Calc If you take 21.3% of 9820 you really end up with 2091.66. Maybe you missed inputting the last digit of 9820 and used 982
Ok! Thanks