Solved: Need a help in formula

Anonymous · ‎07-07-2022

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

johnt75 · ‎07-07-2022

Assuming that Qty is a measure, you could use

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

johnt75 · ‎07-07-2022

Assuming that Qty is a measure, you could use

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

Need a help in formula