Problem in rounding values in a web data rock pivot table

Question

Yesterday we noticed that several values in our web data rock pivot table were not rounded to the second digit as specified by the Format cells settings. The digits after the decimal point were much more. Could this be some kind of bug or was it a temporary issue? I think the problem is with rounding numbers in a period. Today the problem is gone, but we are not sure if it won't happen again.

Checked our angular code. Tried to generate the same table the next day.

Answer 1

The issue may have been caused by some inconsistency in the data or the report (for example, the measure name was changed in the loaded JSON or CSV). You could set the decimal places using the default formatting. This guarantees that this format is applied to each measure unconditionally:

"formats": [
    {
        "name": "",
        "decimalPlaces": 2
    }
]