Calculating Column % based on Row value

In Income Statements is common to calculate a % based on a "Net Sales value" in a row, as follows.

Statement Level 2Jan%
Gross Sales$113,894,029117.9%
Freight Revenue$00.0%
Sales Returns-$427,9570.2%
Cash Discounts-$2,587,6871.1%
Rebates & Other-$14,254,6545.9%
NET SALES$96,623,730100.0%
Standard Cost-$161,325,16366.6%
Standard Margin$39,929,72233.4%
PPV-$5,552,0002.3%
Rev. & Inv / non Recurring-$305,7070.1%
Freight Variance-$395,4730.2%
Freight Expense-$18,962,36310.7%
Allocation - Mfg Variance$11,029,0404.6%
Allocation - Staff-$4,119,2841.7%
Gross Profit$23,623,93523.0%
Customer Support-$3,283,8051.4%
Samples - Expense-$351,4800.1%
Marketing-$1,364,7270.6%
Selling & Service-$13,282,3395.5%
Regional Warehouse$328,7420.1%
Allocation RDC$474,7520.2%
Allocatioin General Selling Exp$00.0%
Bad Debts$00.0%
Allocation SG&A-$2,292,5110.9%
Total SG&A-$19,771,3678.2%
Operating Income$12,852,56814.8%

 

Any suggestions to build this in beastmode?

 

I tried calculating in my dataflow an additional column with the "Net Sales Value" for every row, and it worked.

But when I start to apply filters to the card (e.g. by region), the calculations are incorrect because the "Net Sales Value" is valid only "without filters".  So I need to calculate this "Net Sales Value "on the fly" in a beastmode formula.

 

Any suggestions for this?

Comments

  • Such a good question and a big need to fulfill.

    Domo's out of the box cards aren't very good at nested, heirarchical financial statements.  And row level value versus aggregated value comparison can be difficult as well.

    Frankly, I've used Domo app store apps or custom apps for the best financial reporting in Domo.

     

    In case that's not possible, you could experiment with window functions in your beast modes.  I don't think they're fully supported but can work with the right syntax.