No. of Columns that can be created in 6 data types available in Design Worksheet for SF Compensation

[sd07]

Hello Experts,

Please help me by confirming Maximum number of Columns that can be created in 6 data types(String, Date, Number, Amount, Money, UserName ) available in Design Worksheet for SuccessFactors Compensation.

Thank You.

Sanket Deshmukh

Consultant -KPMG

[Former Member · Accepted solution]

Hi

As far as I know, there is no maximum number of columns. However, there is a maximum number of REPORTABLE columns for each type. Is this what you mean?

Phil

[Former Member · Accepted solution]

From the latest workbook, this many columns can be reportable. You can have many more that are NOT reportable.

- 30 String

- 5 Date

- 100 Numeric (Percent/Money/Amount)

Note that any Money and Amount columns that are not reportable but do have "Calculate Total" selected are counted in that number.

This is as of 2022 H2 release. It may change in the future.

[sd07]

The customer wanted to know the exact number of columns in which we can create at the time of configuration in the design worksheet.

Thank you Phil, For the insights. 🙂