Example: Total value is 30, Sales is 7. so when i check percentage calculation, Percentage = (sales/total)*100. but output shown is 0. how to check percentage?
Solved
How to round of method remove to division calculation in Report Designer
Best answer by jesuscruz97
I got the same issue and figure it out. When you add to the variables add the values with decimal places.
For examples: If you have $totalitems +1, use $totalitems + 1.00
when you make the division it will bring decimal places in the result.
Jesus
+15Can you show me the formula on the Report. It this a Total on the Report or on each line would need to see it to advise as 0 implies you must have one of the fields wrong
Dermot Comerford
+15I would need to see it on the report itself as your formula is correct but where is the TotalNumber and TotalGood getting its value from as in the lines on the report. I suspect these are not getting their values from the detail section?
Dermot Comerford
1 person likes this
The reportfooter Total line Variables are working. then when i give $totalnumber/$totalgood output coming to 4, not showing to 4.28 , its take roundoff, so i need proper value
dcomerford wrote:
I would need to see it on the report itself as your formula is correct but where is the TotalNumber and TotalGood getting its value from as in the lines on the report. I suspect these are not getting their values from the detail section?
i get grouping tab, see my screenshot under total have show correctly
+15Have you tried =[$TotalGood]/[$TotalNumber] i dont have the report to try it on
Dermot Comerford
1 person likes this
dcomerford wrote:
Have you tried =[$TotalGood]/[$TotalNumber] i dont have the report to try it on
No still show to 0.00
+1Hi,
I have a question, why are you using the “POW” function? Do you need the number to be squared? Also, I would like to see the “format” atrribute value for that field.
Miguel Q
1 person likes this
miguel80 wrote:
Hi,
I have a question, why are you using the “POW” function? Do you need the number to be squared? Also, I would like to see the “format” atrribute value for that field.
No need to Squared. just i want 4/25 value is 0.16, but its show 0. thats is the problem
I’m also experiencing the same issue with formulas seemingly not calculating correctly. I’m building a custom time summary report that tracks billable hours, non-billable hours, and time off for each employee:
Here is an example where we fetch the relevant fields, we then divide the [35 billable hours ] / [43 total hours] and expect to see 81.4%. Instead, we see 0% Billable. Correct formula below for Current Period Billable % column:
Interestingly, when I eliminate the “time off” from the total hours, then I correctly see the expected answer of 100% (35 hours / 35 hours) . This tells me somehow Acumatica is either treating this division calc as binary? or maybe has some severe rounding logic going on under the hood?
Has anyone else ever experienced this? Any thoughts on what I’m doing wrong?
I got the same issue and figure it out. When you add to the variables add the values with decimal places.
For examples: If you have $totalitems +1, use $totalitems + 1.00
when you make the division it will bring decimal places in the result.
Jesus
Jesus Cruz
1 person likes this
+13You should also be able to force calculations as a decimal by using CDec:
=$BillableHours/CDec($TotalHours+CDec($TimeOff))
Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.