asked on August 1, 2023
Hi team
Is it possible to set different number of decimal places (for the same column) in the pivot view and in the drill down view? My client would like to see round up numbers in the pivot view, but when drilling down would like to see the whole number as 'details'.
⋅ August 1, 2023
Hello, Dan!
Thank you for reaching out to us.
To be on the same page, could you please confirm our following assumptions:
1. Under the "drill-down view," do you mean the pop-up with raw data which opened while double-clicking on the cell?
2. Regarding the question from the following thread: https://www.flexmonster.com/question/issue-is-decimal-format/, the default behavior of Flexmonster is to add the number of decimal places set in the formatting.
Here is a JSFiddle sample illustrating our point: https://jsfiddle.net/flexmonster/a9p62r7n/.
Is the example in the provided screenshots the desired behavior of Flexmonster? So the 5-decimal precision would remain in the expanded fields, but the row totals would be rounded to an integer?
If some of our guesses are inaccurate, we would be very grateful for a more detailed description of the use case.
Looking forward to hearing from you.
Best regards,
Solomiia
⋅ August 2, 2023
Hi Solomiia
⋅ August 2, 2023
Hello, Dan!
Thank you for your swift response.
Kindly note that the desired behavior can be achieved by using the customizeCell() API call. This API call allows you to customize labels shown on the grid without changing the real data. So, the idea is to round necessary cells with 5 precision while still having the raw data in the drill-through view.
We have prepared a JSFiddle to illustrate the idea: https://jsfiddle.net/flexmonster/3j2h864n/. You can double-click any cell with a number to see the not rounded data underneath.
Please let us know if the described approach works for your case.
Kind regards,
Solomiia
⋅ August 3, 2023
HI Solo
Thanks, that's exactly what we are trying to achieve.
Back on the aggregated value not showing the correct number of digits issue (https://www.flexmonster.com/question/issue-is-decimal-format), do we have any progress on that please? As seen in the attached files, the sum in flexmonster is showing 0 digits when it's not expanded, but showing 5 digits when clicking on the expand triangle.
⋅ August 3, 2023
Hello,
Thank you for the feedback.
We could not reproduce the described issue on our side. In the following JSFiddle, it seems that everything works as expected: https://jsfiddle.net/flexmonster/fzweychr/
Could you please edit the example above to show us the issue? It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ August 4, 2023
Hi Nadia
Yes that's understandable. This issue only occurs in one case, but it's not happening on the other. So I am guessing it must be some specific settings combinations that triggers this, unfortunately I am not able to pin point what it is at the moment.
⋅ August 4, 2023
Hello,
Thank you for the response.
You can check if there is any customizeCell code that may override the formatted value when it is not expanded. We will be more than happy to assist you if you find any further details.
Feel free to contact us if other questions arise.
Kind regards,
Nadia
