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]

Anonymous's avatar
Anonymous
Not applicable
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,

 

I'm glad to hear that you have resolved your issue. Please kindly mark your solution as answer. It will help others with relevant issues find the answer more easily. :smileyhappy:

 

Thanks,
Xi Jin.