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.
Solved
Profit and Loss - Line Percentage to Total
+3Best answer by Laura02
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 ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.