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 invoice line, but the payment is a total amount for the invoice. Now I need to deduct the amount of special invoice line marked as "S" under the column "InvLine Type" from the total payment, and the calculated amount should be displayed beside each invoice line under the same invoice.

Thanks in advance.

Need Help

2 Replies

  • 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.