Forum Discussion

Itchn2go's avatar
Itchn2go
Copper Contributor
Oct 11, 2020

Incorrect Productx calculation

I have this equation: =if (contains (RELATEDTABLE('ItemMaster 1'),[ItemGroupPrefix],"Equ"), PRODUCTX(RELATEDTABLE('Invoices 1'), 0.4 * 'Invoices 1'[LineTotal]),0)   this looks at a column on a...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 11, 2020

Itchn2go 

Thank you. But to which table you add calculated column and how this table is related to ItemMaster 1 and Invoices 1 ?

Itchn2go's avatar
Itchn2go
Copper Contributor
Oct 11, 2020

Thanks for the effort but I am giving up.  😞

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 12, 2020

    Itchn2go 

    Great, thank you for the update

    • Itchn2go's avatar
      Itchn2go
      Copper Contributor
      Oct 13, 2020

      SergeiBaklan  Just an update. I got it to work.   Changed Productx to Sumx

       

      Thanks. 

Resources