Forum Discussion
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
Assuming that Qty is a measure, you could use
Qty % = var currentQty = [Qty] var totalQty = CALCULATE([Qty], ALLSELECTED()) return DIVIDE( currentQty, totalQty)
johnt75
Super User
Super UserAssuming that Qty is a measure, you could use
Qty % =
var currentQty = [Qty]
var totalQty = CALCULATE([Qty], ALLSELECTED())
return DIVIDE( currentQty, totalQty)