Calculated Key figures showing * values occasionally

[former_member574801]

Dear Experts,

I have created a report with a calculated key figure where the formula is Column 2 % Column 1 for column 3 . Some of the values are calculated correctly while some are detected by the exceptions arrow but only visible as *. i have aligned column 3 as descending and if we calculated the missing values, they would fit right in the sort order. Please suggest a solution.

[former_member390432]

Hi Kamalika,

This question is duplicated since the moderator has moved it for C4C Analytics related Tag.
The answer for this question can be found in the second question you have done right there Calculated custom Key figure shows * values occassionally


Thank you;


Best regards.
Mirelle Freitas.

[IngoH]

Hello Kamalika,

this forum is for SAP Analytics Cloud. perhpaps post the question in the Hybris area

regards

Ingo

[former_member574801]

I wasn't able to find the proper tag. What is it?

[IngoH]

Hello Kamalika,

is this with SAP Analytics Cloud ? Is this a live data connection or did you upload the data ?

Could you share the details of the model and the calculation ?

Thanks

Ingo Hilgefort, SAP

[former_member574801]

Column 1 and column 2 are custom key figures as well created to support currency conversion for some extension fields. These extension fields were created using the key user tool and are calculated Amount fields (two extension fields multiplied to each other, one amount, other quantity). As you can see, column 1 and column 2 values are reflected correctly.

The extension fields are created on the item level of an opportunity. As the extension fields are of type - Amount, they automatically qualify as key figures.

Column 3 as I have said Column 2 % Column 1 (percentage deviation). I hope this is enough information for you. Please let me know if you need more.

This is a report for SAP Hybris Sales cloud created using Business Analytics workcenter, I do hope I got the tags correct.