Calculated values not inheriting the Measure properties

[vinothclement]

Hello All,

Could you please confirm if the below-mentioned is expected behavior in SAC?

We are on a Live connection. In our SAC reports, we are creating a few static rows that are calculated based on the values in rows that are flowing into the report dynamically. We had set the measures scaling to 1000, decimals to 0.0, and Negative values in ().

On the calculated rows, we see that the values are not inheriting the properties of the cell that we are referring to.

Account | 006.2022 | 007.2022

Gross Sales |(1234.5) | 4567.8 << (this row is dynamically populated)

New Sales | -1234.567 | 4567.897 << (this row is calculated based on Gross Sales row)

Expected Result,

New Sales | (1234.5) | 4567.8 << (this row is calculated based on the Gross Sales row)

We are expecting the properties that had been set to the measures to reflect on the calculated measure as well. But, that does not seem to be the case.

Is this normal behavior? Any insights would be helpful.

Regards,

Vinoth V

[DebjitSingha · Accepted solution]

Hello vinothclement,

We notice this behavior with newly added columns and rows. What we do is - select entire measure part of the row (newly added row) and explicitly define number format. Like below:

This works for us.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

-Debjit

[vinothclement · Accepted solution]

Hi Debjit,

Thank You for the response.

This is the same approach even we are doing.

Regards,

Vinoth V