Forum Discussion
Solved
Divide two columns in a group by.
Sorry, I know this seems so simple, but I can’t figure it out. In the following example, how do I take the [ListPriceExtended] and divide it by the [Qty] to get the [AverageListPrice] for each li...
I think I know where you went wrong - did you add AverageListPrice as a "New measure" or a "New column"? It looks like "New column", but it should likely be a "New measure".
mike_honey
Memorable Member
Memorable MemberI think I know where you went wrong - did you add AverageListPrice as a "New measure" or a "New column"? It looks like "New column", but it should likely be a "New measure".
Looks good. I think I got it. Thanks.