SAP Knowledge Base Article - Public

3159226 - NONEX in Custom Key Figure


You have created a custom calculated key figure, however when you use it in a report you notice that it shows NONEX instead of the expected values.


  • SAP Cloud for Customer
  • SAP Business byDesign


This can happen in the following scenario:

You are using the options %CT  or %GT in your key figure formula. You are also using a a matrix table, i.e. characteristics in both rows and columns.

%CT and %GT indicate how high the percentage amount is with regard to the result. Result here means the result of the aggregation at the next-highest level (intermediate result).

When you have a flat table, i.e. characteristics in the rows and key figures in the columns, the aggregation is quite simple - it happens based on the chosen characteristics and their order in the rows. However when you have a matrix, i.e. characteristics in both rows and columns, the aggregation is more complex and the system aggregates across rows and columns.


Unfortunately the percentage cannot be calculated using %CT / %GT in a matrix. If you would like to use this option in the key figure calculation, please use a flat table.


key figure, nonex, custom calculation, formula, percentage, business analytics , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions ; SAP Cloud for Customer core applications all versions