cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Adjusting for Rounding Difference

amrita_goswami
Participant
0 Kudos
204

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:

 

AccountProductEntityDateValue

Quantity

Sparkling Water

#

Dec.2018

210

Post Allocation we have:

 

AccountProductEntityDateValue 

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

Accepted Solutions (0)

Answers (0)