Forum Discussion
Calculating Changes in Cumulative/Appended Report
This is great and hugely helpful! The only problem is (and I should have included this scenario in the example):
When there are multiple changes to the same cost center simultaneously, only the first change in the logic is captured. For example, if both the Cost Center Name and Cost Center Owner changes for cost center 345, the Change Type field only captures "Cost Center Name Change" as that is the first item in the logic..
Is there any way to append these values automatically so that the Change Type field says something like "Cost Center Name Change + Cost Center Owner Change"
I understand I could manually code this like:
[Previous Cost Center Name] <> [Cost Center Name] && [Previous Cost Center Owner] <> [Cost Center Owner], "Cost Center Name Change + Cost Center Owner Change"
The problem with this, though, is that the data I provided is only a sample, and the actual number of fields I need to track changes for is 9. So, that would require about 400 million possible combinations (9^9) which is obviously infeasible.
Thank you again for getting me this far, and if you have any advice on this, I would reaaaally appreciate it!
rajendraongole1 Just following up on this to see if you know of a solution/workaround to handle multiple changes (a cost center could experience one change (ex: Cost Center Name), or it could experience multiple changes simultaneously (ex: Cost Center Name, Cost Center Division, & Cost Center Owner))..
Correction to my earlier statement: With 9 fields subject to change, I believe there are ~363,000 different combinations (excluding repetitions) which, still, makes it unrealistic to code.
Instead, is there a way to append the 'Change' values as I mentioned before or, if it would be easier, would it be possible to have the code continue to execute after a change is identified, and put each change on a separate line? For example:
| Cost Center Code | Change Type |
| 345 | Cost Center Name Change |
| 345 | Cost Center Owner Change |
| 345 | Cost Center Division Change |
Thanks again!