Hi,
I was using
“formula”: “sum(\”X\”)/sum(\”Y\”)”,
how to set particular column decimal value as zero
Hello,
Thank you for your question.
In case your requirement is to limit the number of decimal places, we suggest checking out the format
object and particularly its decimalPlaces
property.
It defines the number of decimals to appear after decimal separator in the fractional part of the number. The default value is -1
, it means the number will not be changed, and it will be shown in its original form.
More information about the object and the whole list of its properties can be found in our documentation.
Please check out an example we have prepared for you. The number of decimals is set to 0 for the “Price/Discount” hierarchy.
Also, number formatting can be configured through UI. Please hover over the “Format” button and choose the “Format cells” option from the drop-down list. The pop-up allowing to configure the desired view will be opened.
Finally, our team would like to notice that it is always possible to configure the desired view through UI and save the report using the “Save” button on the Toolbar. It allows further retrieving the configured view.
We hope it works for your case.
Do not hesitate to contact us in case of additional questions.
Best regards,
WebDataRocks Team