Logic Script to multiply data in 10.0 HANA

[Oleks_Master]

Hello all,

I need to multiply two sets of data on different Accounts and different Products. Result should be saved on third account per products.

Please see the picture:

Which options do I have to achieve this:

- Variable?

- Lookup?

- For/Next?

- RunAllocation?

Best regards,

Oleksandr

[former_member186338 · Accepted solution]

But what is the issue?

Assuming default.lgf (to have the result after data is saved):

Using standard when/endwhen:

*WHEN ACCOUNT

*IS A1.611

*WHEN PRODUCT

*IS BAS(PR08)

*REC(EXPRESSION=%VALUE%*([ACCOUNT].[A1.6522],[PRODUCT].[PR_NA]),ACCOUNT=A1.612)

*ENDWHEN

*ENDWHEN

Vadim

[Oleks_Master · Accepted solution]

Hi Vadim,

I tried the combination ([ACCOUNT].[A1.6522],[PRODUCT].[PR_NA]), but I did not use PRODUCT dimension in *WHEN statement. So, I got an error and eventually thought that this combination is not supported.

Thank you very much, Vadim.

Best wishes,

Oleksandr