cancel
Showing results for 
Search instead for 
Did you mean: 

how to move data to the needed records

0 Kudos

Hi all,

In our scenario, where volume and percentage are measures, the controller sends a percentage that is stored in the database as the screenshot below

The following data are already present in database:

I would like to have this result:

in order to do the following calculation: average of previous years increased of percentage à (10+20+30)+(10+20+30)*5%

Thank you in advance

View Entire Topic
Jay_Gandhi
Advisor
Advisor
0 Kudos

Hi there,

I would encourage you to look at our various guides on creating data actions and advanced formulas. The above is a fairly common scenario.

Please see the following areas:

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/812f4d02ac13401d990ce...

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/e88b9a87633c4e19a0dbd...

Jay