Help with Data Buffers

Question

Hi everyone. I am looking for some assistance with using data buffers for a revenue planning form.
Essentially, budgeted revenue growth percentages will be input individually for each brand by month. The total PY Actual revenue for each brand by month will be loaded into OneStream.
The formula to forecast budget is:CY Budget = PYAct * (1 + Growth % / 100)
While I can calculate each CY Budget cell individually for each brand by month, this would be a tedious and very long process since there are 26 brands and 12 months, which would require 312 individual calculations.
I would like to use a data buffer instead to calculate CY Budget by looping through each brand (and across all months from Jan 2022 to Dec 2022). However, I am unsure of how to do this and would appreciate guidance.
For ease of reference, I have also attached a screenshot of my cube view.

Sergey · Answer

Hello,&nbsp;More than a data buffer, you will need a multiplyunbalanced formula. This post from Cameron is covering it :&nbsp;https://blackdiamondadvisory.com/2022/03/15/keeping-your-balance-with-unbalanced-math/&nbsp;Regards,

Henning · Answer

Hi, just in case the brands and "AMZN" displayed in your screenshot are not just a random example, you may want to blur out those parts depending on your employer's / customer's stance on how open they are with regards to sharing (small) parts of their application.

Forum Discussion

Help with Data Buffers

Related Content

Data Buffer

Data Buffer

Unable to log data buffer

Change data buffer based on time

Use data buffer in dashboard data set