Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

-

-
  • SergioSilvaPT's avatar
    SergioSilvaPT
    4 years ago

    Hi Anonymous ,

     

    Given the example that you sent me in PM:

     

    I think the following measure could solve your problem:

     

    Revenue = (SUM(Table[Unit price]) - SUM(Table[Cost price])) * quantity

     

     

Signore_Ands's avatar
Signore_Ands
Icon for Advocate III rankAdvocate III
4 years ago

I take it you have a separate table that holds the transactions (with the quantities)?

Are you trying to multiple the quantities in a transaction table by the unit prices in the debtors table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thats what i'm trying to do but i don't have a "quantity" table for the debtors, all the tables you see above is what i have. Is it still possible or do i need to have quantity table to calculate the revenue per debtor. 

    • Signore_Ands's avatar
      Signore_Ands
      Icon for Advocate III rankAdvocate III
      4 years ago

      to calculate Revenue you will need more data yes.