Allocation in SAC

[Freddie]

Hello,

I have a scenario that I need help with. I upload data with a split on the members of [d/COUNTRY] and on [d/STORE] = "#". The same total is uploaded afterwords, but the other way around i.e. with a split on the members of [d/STORE] and [d/COUNTRY = "#". I now need to merge these two together with a Data Action while having almost the same original split on [d/COUNTRY] and [d/STORE].

Anyone have any ideas?

[N1kh1l]

It would be helpful if you provide the 2 sample records and then final data record as per your expectation. Reading your post I am not sure what is the link between 2 records

date	country	store	value
202401	C1	#	100
202401	#	S1	100

[Freddie]

Hello @N1kh1l

Thx for replying!

Would look something like this after the upload:

Best regards

[MoonJun · Accepted solution]

Hi @Freddie 

Please refer to the Advanced formulas script, which populates the Allocated amount based on the Driver value Country "#". 

Source Value

Driver Value

Advanced Formulas Script

MEMBERSET [d/Measures] = "Amount"
MEMBERSET [d/Date] = "202412"

VARIABLEMEMBER #Site_Total OF [d/SITE] 

DATA([d/SITE]=#Site_Total,[d/Country]="#") = RESULTLOOKUP([d/Country]="#")
DATA() = RESULTLOOKUP([d/SITE]="#") * RESULTLOOKUP([d/Country]="#") / RESULTLOOKUP([d/Country]="#",[d/SITE]=#Site_Total)

Allocated Result

I hope this helps solve your issue.

Moonjun