Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Grouped calculated total in different table

Hi,

 

I'm having trouble with making a calculated column where the value is calculated from another table. The value however needs to be grouped to work for my table. I have the following tables:

'Costs & Proceeds' table. Note that every change is a new event, and I need a total (proceeds - costs) per SO number.

Costs/Proceeds table

'Service Order' - And this is the table where i need my total to be in (need the total row)

Thanks,

Nick

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Got it working with a new table like so:

     

    Accrual Table = SUMMARIZE('Costs & Proceeds';'Costs & Proceeds'[SO Number];"Accrual";SUMX('Costs & Proceeds';'Costs & Proceeds'[Proceeds]-'Costs & Proceeds'[Costs]))
     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    You can try the formula below to create a calculated column: 

    Total Rows =
COUNTROWS ( RELATEDTABLE ( 'Service Order' ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Got it working with a new table like so:

     

    Accrual Table = SUMMARIZE('Costs & Proceeds';'Costs & Proceeds'[SO Number];"Accrual";SUMX('Costs & Proceeds';'Costs & Proceeds'[Proceeds]-'Costs & Proceeds'[Costs]))