hi all,
i am new to domo and would like to seek your kindly advise regarding on my question.
i make a ETL and the structure is like below.
and next step i make a pivot table and segregate the "monthly_balance" by "source" (actual and budget)
the next step is i want to calculate the "monthly_balance" percentage difference between the 'actual' and 'budget' and attached in table last column
for example the first line would be ((52935094.74-52746575.11)/(52935094.74))*100% = 0.356%
same calculation is apply for the rest of lines.
i try to make a beast mode calculation for this purpose but seem not work and not fit my expectation.
is there anyone could provide me some suggestion?