Forum Discussion

sam245gonsalves's avatar
sam245gonsalves
Icon for Helper I rankHelper I
5 years ago
Solved

Column Multiplication gives 0

Hello I have the below table with the following columns : Column 1 is hidden as its sensitive but contains brand. The rows highlighted in Yellow are Brand A & un-highlighted rows are Brand B   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    sam245gonsalves 

    Try create either a column or a measure as below:

    Column = [value]*[qty]-([value]*[qty]*[Discount_value])

Measure = 
var cardsales_= SUM([value])*SUM([qty])
Return cardsales_-cardsales_*SUM([Discount_value])


    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.