SAC Adjusting for Rounding Difference

[amrita_goswami]

Hello SAC Experts,

Looking for guidance regarding adjusting Rounding differences in our data pre and post allocation.

For example, our preallocation data is something like this:

Account	Product	Entity	Date	Value
Quantity	Sparkling Water	#	Dec.2018	210

Post Allocation we have:

Account	Product	Entity	Date	Value
Quantity	Sparkling Water	Alloc	Germany	Dec.2018	49.60
Quantity	Sparkling Water	Alloc	France	Dec.2018	69.80
Quantity	Sparkling Water	Alloc	UK	Dec.2018	90

There is a rounding difference of 60 cents, which needs to be adjusted against the first record.

I am able to read the difference of 60 cents in the Data action into a variable @Diff. I am struggling to add it just to one record in the post allocated data.

The statement below adds 60 cents to each row.

Data ([Audit] ="Alloc") = Resultlookup([Audit] ="Alloc) + @diff

Since we do not know what values of entity or Account  or Products will be populated at run time, how can we narrow down to one record per period? This is a simplified version of the dataset, we have several more dimensions in the model which I am not included here to keep the example simpler.

Please suggest how this can be achieved.

TIA

Amrita