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.
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.