December 9, 2016
I do manual work when creating reports with calculations, meaning I have reference table and then when I create report I link that reference in every 10th row. I assume this can be done smarter way, and I tried it with offset formula but just cannot figure out the syntax.
I have attached the example - in yellow cells I would like to figure out the formula for doing this and avoid this manual workaround.
Can someone please help me?
Thank you for ideas!
November 1, 2018