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]

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

This is happening because you are creating a measure and not a calculated column, since you are refering to CurrentRebates[RebatAmt] it returns this error because a measure need an agregattor on column level.

 

Check if you are adding a measure or a column.

 

Regards,

MFelix

  • 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.