Hi, everyone here started from zero, so I would say it is never too late to start looking into some basic coding 🙂
As you say, using a dynamic member formula will be easier for the use case you describe. And the UD8 calculation can then also be easily re-used in other reports or Excel Quick Views.
On your question, a good way to start is here:
Dynamic Member Formulas and Cube Views
Just start small, by pulling a single number and then add more dimensional details and / or calculation logics to it. This should give you a good feeling of how it works.
Snippets in OneStream as well as the Blueprint also contain a variety of examples, as was discussed here:
Solved: UD8 Reporting Helpers - OneStream Community
On top of that, if you search for "UD8 dynamic" or "Dynamic calculation" or something similar in this forum, you will find quite a few discussions with a number of code samples you might be able to leverage as well.
Keep in mind though UD8 is most commonly used for such reporting helpers, dynamic calculations can be used in the account dimension as well as all UDs. UD8 is just most commonly chosen as the ones "before" are typically used for data model related details such as cost center, audit, etc.
