Forum Discussion

EZV12's avatar
EZV12
Helper IV
3 years ago

Display the same calculated amount for each line within the same invoice in a table

Hello all, I need help for a formula within a table.  This table is called "FactInvoicePayment", there are many invoices inside and each invoice has many invoice lines.  I have the amount of each i...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

EZV12 , You can get invoice amount on each line like

 

new column = sumx(filter(Table, [Invoice] = earlier([Invoice]) ), Table[Amount] )

 

measure

measure = sumx(filter(allselected(Table), [Invoice] = max([Invoice]) ), Table[Amount] )

 

or

 

measure = sumx(filter(all(Table), [Invoice] = max([Invoice]) ), Table[Amount] )

 

or

 

measure = sumx(filter(all(Table [Invoice]), [Invoice] = max([Invoice]) ), Table[Amount] )

EZV12's avatar
EZV12
Helper IV
3 years ago

Thank you for your reply, however, it doesn't work.

What I need is to deduct the amount of special invoice line marked as "S" under the column "InvLine Type" from the total payment (column "Payment", same amount for each invoice line under the same invoice), and the calculated amount should be displayed beside each invoice line under the same invoice.

May you please advise? Thanks

Thanks in advance.