Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

single value for column error

I'm trying to create a column to calculate the following formula:  Profit = ([GPRICE]+CurrentRebates[RebateAmt])-([cost]+[WhsChg]+[FRTCOST]). I am getting an error that: "A single value for column 'R...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I thought that I was using a calculated column.  Anyway, I kept working with it and by using the "Related" function (if that's the correct term), I was able to get the following to work.

     

    Profit = [GPRICE]+RELATED(CurrentRebates[RebateAmt])-[cost]-[WhsChg]-[FRTCOST]

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Anonymous,

 

When we create a measure, it is unable to call a table column directly. You need to do aggregation on it. And this is by design.

 

To resolve your issue, you can try calculated column with your expression.

 

Thanks,

Xi Jin.