Multiplication Sap Analytics cloud

[AngelMesp]

Hello experts,

Im trying to multiply two measures using advanced formulas in a data action but doesnt work, i cant see any result.

 - first measure: Quantity --> Im saving this measure in a previous step with the following code.

(im saving in all dimensions #)

MEMBERSET [d/Date] = "202501" TO "202512"

DATA([d/Measures]="Quantity",
	          [d/P_COMERCIAL]="#",
	          [d/P_CURRENCY]="#",
	          [d/P_FLAG_PERIODOS]="#",
	          [d/P_PLANT]="#",
                  [d/Date]="203112") = 
RESULTLOOKUP([d/Measures]="KVEN02")

  - second measure: porcentaje --> the final user save this value in a table. As you can see, all the values      are stored in #

With this, if i try to save the first value and secondi can successfully. Moreover, i can do an addition or a subtraction and work.

This is my code when i try to multiply

DATA([d/Measures]="Quantity",
                  [d/P_COMERCIAL]="#",
                  [d/P_CURRENCY]="#",
                  [d/P_FLAG_PERIODOS]="#",
                  [d/P_PLANT]="#") =  RESULTLOOKUP([d/Measures]="Porcentaje",									 
                  [d/P_COMERCIAL_CLIENTE]="#",								 
                  [d/P_COMERCIAL]="#",											  
                  [d/P_CURRENCY]="#",											  
                  [d/P_CUSTOMER]="#",										  
                  [d/P_DISTR_CHAN]="#",											  
                  [d/P_FLAG_PERIODOS]="#",											  
                  [d/P_MATERIAL]="#",											  
                  [d/P_PLANT]="#",											  
                  [d/P_REPRESENTANTE]="#", 										  
                  [d/P_SALESUNIT]="#",											  
                  [d/P_ZFAMIAGR]="#",											  
                  [d/P_ZFAMIAGR3]="#") *
RESULTLOOKUP([d/Measures]="Quantity",
	          [d/P_COMERCIAL]="#",
	          [d/P_CURRENCY]="#",
	          [d/P_FLAG_PERIODOS]="#",
	          [d/P_PLANT]="#",
              [d/Date]="203112")

each month have a different value for porcentaje measure

I need multiply Quantity * Porcentaje in the following image, as you can see all 2025 are empty

Please help, im really stuck. I've already read another similar questions, for example:

 - https://community.sap.com/t5/technology-q-a/sac-advance-formula-not-working-for-division-operation/q...

 - https://community.sap.com/t5/technology-q-a/calculation-problem-when-multiplying-resultlookup/qaq-p/...

But i dont know what is my problem.

Cheers.

[AngelMesp]

Hi everyone,

Im still stuck, does anyone know how I can do it?

please help!!

[AngelMesp]

Hello,

[AngelMesp]

Hello, im still stacked 😞

[AngelMesp]

Hello, im still stacked 😞 can someone help me please