Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need a help in formula


Dear Experts

 

Can someone please help me achieve this % value in the measure column based on the total of Qty.
Please help me with the formula.

Thanks in advance
MAHAD

Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Assuming that Qty is a measure, you could use

    Qty % =
var currentQty = [Qty]
var totalQty = CALCULATE([Qty], ALLSELECTED())
return DIVIDE( currentQty, totalQty)

1 Reply

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    Assuming that Qty is a measure, you could use

    Qty % =
var currentQty = [Qty]
var totalQty = CALCULATE([Qty], ALLSELECTED())
return DIVIDE( currentQty, totalQty)