Forum Discussion

giacomobonetti's avatar
giacomobonetti
Frequent Visitor
9 years ago
Solved

Error when creating a calculated column

I want to create a calculated column out of the division of a column, which is in one table, and a calculated column which is in another table.   The formula I am using is:    Column = -DIVIDE(Ex...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Probably need to use RELATED or RELATEDTABLE in your calculation.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi giacomobonetti,

Is there relationship between ExpensesData and SalesData table? Just as Greg_Deckler posted, you should use RELATED function. Could you please share the sample data or screenshot for further analysis?

 

Best Regards,

Angelia

giacomobonetti's avatar
giacomobonetti
Frequent Visitor
9 years ago

Thank you both for your help. I solved the problem by creating new columns directly in the dataset, although I will keep in mind the function in case I find myself in the same situation again.

 

Cheers,

Giacomo