Hi all, please advise steps or show article explaining how to add a column in Report Definitions showing percentage of a line compared to the total of its group. Ex: percentage of materials compared to direct expense total.
Answer
Profit and Loss - Line Percentage to Total
+3Best answer by Laura03
Hello,
Look for the @BaseRowCode function.
In the Row Set, each detail line is related to its denominator in the Base Row column.
In the Column Set, the value for the % Column C (your above example), the formula looks something like =B/@BaseRowCode.
Kristian Harianja
+19Hello,
Look for the @BaseRowCode function.
In the Row Set, each detail line is related to its denominator in the Base Row column.
In the Column Set, the value for the % Column C (your above example), the formula looks something like =B/@BaseRowCode.
~ Laura Barber, WM Synergy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.