Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently running in to an issue regarding number validation between a pivot table and a graph. They are both using the same exact expression and dimension, i have made sure of it. I even checked the number tab in the chart and graph properties. However, the pivot table is giving me different rounding numbers than the bar graph. For instance doing the math on a calculator i am getting a number such as 31.958. This number will be 32.0 in the pivot table, yet in the graph this number comes up as 31.9. I have tried the rounding expression and this seems to not really do anything. Is there a reason that the Bar graph rounds differently than the pivot table?
This would be rather disappointing, if it really happens. Did you check that you also use exactly the same format pattern for the number? A sample application would help.
Yes i did. I have the number set to decimal fixed to 1 decimal place and the number looking like #,##0.0
make the num fomat to #,##0 . hope this might give you the crrt solution
Although this does make the charts correct. We wanted the number to be more accurate and not round to the nearest interger, but rather to the nearest tenth.
Rather than using the number formatting try adding Num() to your expression and format here then use the expression default (note in QV11 SR1 you may have to rebuild the chart for expression default to work)
Although this did help solve one object, and linked the chart and graph correctly. It is not helping with all of them. So i am still trying.
Rule of thumb, formatted expression values are generally more reliable than a visual editor
Can you post a small sample file that demonstrate your issue?
Is it maybe related to this issue?
Ths issue has been resolved. Thank you everyone for your help. Had to do with the usage of a Sum(Aggr( function in what we were dividing by.