Hi! In charts, you'll once again need to find the "formatting" button and do a "custom" implementation. Here, you can modify how you want the numbers to be displayed. You can apply the same to reports, pivots, etc. If you're still struggling with this, please reach out to our support team for further help. Thank you!
@@rupesh131313 Hello again. Thank you for replying. Unfortunately, this isn't a question we can answer via the YT channel because it requires a deeper look. Please reach out to the support team and have them investigate. What we do know, however, is that if your numerical data in the table is in thousands or billions, then you won't be able to automatically convert that into millions without customization (most likely JavaScript). The data, using standard features, will still have a currency in front and proper punctuation (ie $10,000 or $10,000,000,000), but it won't be presented in millions. Hopefully this helps.
Thanks for replying. I have connected with support team and they have suggested me a workaround to convert data in Table then use the same as Million however in chart and pivot, I am getting the value but Million is not listed there e.g. $1,000,000 = $1.0, I am getting like this.
@@rupesh131313 Please continue to work with them as that is the proper channel to get technical questions answered. It would be worthwhile to request a screen-share so that they can see what you're trying to accomplish. You can also attend our free training classes and ask the instructor if they can assist you: www.caspio.com/training/ Thank you!
Hi Ned,
How do we show millions for currency in Chart, pivot table and data pages
Hi! In charts, you'll once again need to find the "formatting" button and do a "custom" implementation. Here, you can modify how you want the numbers to be displayed. You can apply the same to reports, pivots, etc. If you're still struggling with this, please reach out to our support team for further help. Thank you!
@@CaspioInc Thanks for replying however in custom there is no option to show currency in Millions, please suggest how to achieve it
@@rupesh131313 Hello again. Thank you for replying. Unfortunately, this isn't a question we can answer via the YT channel because it requires a deeper look. Please reach out to the support team and have them investigate. What we do know, however, is that if your numerical data in the table is in thousands or billions, then you won't be able to automatically convert that into millions without customization (most likely JavaScript). The data, using standard features, will still have a currency in front and proper punctuation (ie $10,000 or $10,000,000,000), but it won't be presented in millions. Hopefully this helps.
Thanks for replying. I have connected with support team and they have suggested me a workaround to convert data in Table then use the same as Million however in chart and pivot, I am getting the value but Million is not listed there e.g. $1,000,000 = $1.0, I am getting like this.
@@rupesh131313 Please continue to work with them as that is the proper channel to get technical questions answered. It would be worthwhile to request a screen-share so that they can see what you're trying to accomplish. You can also attend our free training classes and ask the instructor if they can assist you: www.caspio.com/training/ Thank you!