Income Statement

I have a dataset of all accounts but I need to create calculated rows like Income before taxes, net income, etc. 

 

What would be the best way to create income statement cards?

Comments

  • GrantSmith
    GrantSmith Indiana 🔴

    You can create custom column calculations using a Beast Mode / Calculated Field. Here's knowledge base article with some more information on those. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode

     

    If you're wanting to know how to do it across the entire data set then you'd need to do some additional calculations using a window function inside your beast mode which is more complex and requires the feature to be enabled in your instance (you'd need to talk with your CSM)

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    this is a tough project. I've seen it done poorly ... a lot.

     

    you'll need to start with what I call an 'account schedule' but it'll need to be granular.

     

    you'll need a minimum of two columns (row_name, and join_account) 

    in the dataset you'll need one row for each account in the calculated row.

     

    income , 4001

    income, 4002,

    cogs, 5201

    cogs, 5301

    profit, 4001

    profit, 4002

    profit, 5201

    profit, 5301

     

    you'll also add the individual posting accounts

    retail sales, 4001

    web sales , 4002

    raw materials, 5201

    shipping fees, 5301

     

    you may want to extend your account schedule with an isInvertSign flag to help adjust values for display purposes.

     

    you'll then JOIN this dataset back to your transactions.  now you can put row_name on the axis and sum(amount).

     

    if you need a freelance consultant who has done this before, https://dojo.domo.com/t5/Job-Board/Freelance-Domo-consultant-available-for-hourly-and-long-term/m-p/49181#M47 this guys is available for short term and long term projects and has a strong focus on leveraging Domo for finance applications.

     

  • @jaeW_at_Onyx  I was able to get to that part, but I am unsure how to create rows like Gross profit, where the calculation is not just sum, but subtraction of sum of cogs from sum of sales. Is there a way for me to create those different calculations for gross profit, operating income, income before taxes?

This discussion has been closed.