Round to 2 decimal in field
I want round: [SUM(<qReportIzpis."Nabava">)/SUM(<qReportIzpis."anQty">*<Upit1."anDimWeight">)] to 2 decimals.
This I show in first field, but in next I want multiply with something else, so I need to round this, to have correctly value on report. I try:
[(round(SUM(<qReportIzpis."Nabava">)/SUM(<qReportIzpis."anQty">*<Upit1."anDimWeight">),2)) * SUM(<Upit2."HRK">)] but nothing happend if I go without round then I have mistake:
[SUM(<qReportIzpis."Nabava">)/SUM(<qReportIzpis."anQty">*<Upit1."anDimWeight">)] = 218.48
SUM(<Upit2."HRK">) = 12.00
that's mean= 218.48 * 12.00 = 2621,76, but report show me: 2621,34, so I need round on 2 decimals. How to do that? THank you.
This I show in first field, but in next I want multiply with something else, so I need to round this, to have correctly value on report. I try:
[(round(SUM(<qReportIzpis."Nabava">)/SUM(<qReportIzpis."anQty">*<Upit1."anDimWeight">),2)) * SUM(<Upit2."HRK">)] but nothing happend if I go without round then I have mistake:
[SUM(<qReportIzpis."Nabava">)/SUM(<qReportIzpis."anQty">*<Upit1."anDimWeight">)] = 218.48
SUM(<Upit2."HRK">) = 12.00
that's mean= 218.48 * 12.00 = 2621,76, but report show me: 2621,34, so I need round on 2 decimals. How to do that? THank you.
Comments
[(round(SUM(<qReportIzpis."Nabava">) / SUM(<qReportIzpis."anQty">*<Upit1."anDimWeight">) * 100) / 100) * SUM(<Upit2."HRK">)]