Forum Discussion

ammartino44's avatar
ammartino44
Icon for Helper III rankHelper III
9 years ago
Solved

Help with relatedtable function

Hello. I'm tryiing to find    =SUMX(Filter(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),'Work Orders1'[WO Type]="Cashout")
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi, ammartino44

     

    From your formula, the data type of column 'Work Orders1'[WO Type] is text, while SUMX function evaluates to numbers or dates and cannot work with values of type String. Beside, the correct syntax of SUMX is: 

    SUMX(<table>,<expression>)

     

    In your scenario, the formula might be like :

    =SUMX(FILTER(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),ColumnName)

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi, ammartino44

 

From your formula, the data type of column 'Work Orders1'[WO Type] is text, while SUMX function evaluates to numbers or dates and cannot work with values of type String. Beside, the correct syntax of SUMX is: 

SUMX(<table>,<expression>)

 

In your scenario, the formula might be like :

=SUMX(FILTER(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),ColumnName)

 

Best regards,
Yuliana Gu