Hi all,
I'm trying to use the report total of a calculated field(Qty * price) to find its
percentage.
Here's an example, I'm looking for a solution to get the percent values in red.
% formula -> (qty * price)
(Qty * price) / report total of Qty * price
eg row 1 $261,508.84 15% -> (261,508.84 / 1,657,473.26)
row 2 $189,183.97 11% -> (189,183.97 / 1,657,473.26)
row 3 . .
row 4 . .
report total $1,657,473.26
Thanks