Question Re: SAP Analytics Cloud Excel Add-in Table Default Number... in Technology Q&A

SAP Analytics Cloud Excel Add-in Table Default Number Format

DBalinski — Mon, 03 Feb 2025 18:28:10 GMT

When I create a table for one of my data models in excel the default number format is showing four decimals. I have checked the style in excel and the style for that type of cell says two decimals but whenever I create a table is shows the four decimals. I know that I can apply that excel style or I can change the table's number format to two decimals but would love if I could save myself the time and have two decimals be the default instead of four. Every document I have found published by SAP on the topic notes that the default format can be set in the model preferences but it never says where that is. Can someone point me in the right direction to change that?

Re: SAP Analytics Cloud Excel Add-in Table Default Number...

Yogeshwar_M — Tue, 04 Feb 2025 05:51:01 GMT

Hi @DBalinski ,

You can change data type decimal places by default in model.

STEP 1. You have to click on measure and select appropriate decimal places.

In the measure you have to change data type as per your requirement here as shown in pic 7 you can change as per your requirement by default in model

Here you can change just change it will default set

Kindly upvote if you find it useful.

Thanks.

Re: SAP Analytics Cloud Excel Add-in Table Default Number...

N1kh1l — Tue, 04 Feb 2025 14:37:13 GMT

@DBalinski

Couple of Options.

If you want to globally set the scale for the measure you could do it in measure configuration.
This is generally not advisable as you might have a mix of financial and statistical numbers with varied scaling requirements. but if it is universal scaling you can set it here.
Other option is to apply the format in Excel table and disable the option of Applying the default format.
If you have model with both measure and accounts you might have to check the structure priority in model preference to know from where the scale and format is being picked up.

Hope this helps !!

Nikhil