pcsoft.us.windevCopyright 2026, PC SOFT1 Nov 2016 10:42:00 Z31 Oct 2016 17:10:00 ZHi all, I was under the impression that using currencies for calculations was the way to use (max.) six decimal places, but that does not seem to be necessarily so. I get a result with only four decimal places instead of the expected 6 decimals. Now I have used numerics as intermediate fields and found it to be correct calculation. What causes the difference in the calculation of currencies? lcyKgPrijs = TblSlachtrapport.DEF_PrijsNoteringWeekprijs // 0.595 lcyBtwPerc = TblBtw.BTWPercentage // 6 lcyKgPrijsExcl = round(lcyKgPrijs / (100.0 + lcyBtwPerc) * 100.0, 6) // lcyKgPrijsExcl is : 0.5613 --> 4 decimals, but should be 6 decimals lnKgPrijs is numeric(5,7) = TblSlachtrapport.DEF_PrijsNoteringWeekprijs // 0.595 lnBtwPerc is numeric(5,7) = TblBtw.BTWPercentage // 6 lcyKgPrijsExcl = Round(lnKgPrijs / (100.0 + lnBtwPerc) * 100.0, 6) // lcyKgPrijsExcl is : 0.561321 is OK Thanks for any hints.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60201/read.awp1 Nov 2016 10:42:00 ZHi Erik, thanks you for your explanation! It makes clear what I have to do to make it work.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60201/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60201/read.awp[WD19] Calculation with rounding on 6 decimalsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60200/read.awp1 Nov 2016 09:43:00 Zoops: second step: 59.5/106 = 0.561321https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60200/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60200/read.awp[WD19] Calculation with rounding on 6 decimalsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60197/read.awp1 Nov 2016 08:28:00 ZSorry Allard for being not clear, DEF_PrijsNoteringWeekprijs is indeed defined as currency in the analysis. Also the other fi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60197/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60197/read.awp[WD19] Calculation with rounding on 6 decimalsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60199/read.awp1 Nov 2016 00:00:00 ZHi Stefan, no miracle! currency has 6 Digits for the decimal part. your calculation first does: 0.595/106 -> 0.00561320…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60199/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60199/read.awp[WD19] Calculation with rounding on 6 decimalsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60193/read.awp31 Oct 2016 22:36:00 ZHi, Is ths a currency : "DEF_PrijsNoteringWeekprijs" If so hwo is that field defined in the analysis? Maybe a currency …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60193/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60185-wd19-calculation-with-rounding-6-decimals-60193/read.awp[WD19] Calculation with rounding on 6 decimals