on 2024 Apr 05 3:07 PM
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
Request clarification before answering.
User | Count |
---|---|
76 | |
30 | |
10 | |
8 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.