Menu
GP

Tip: Use Multiple Formulas in the Same Column in Management Reporter

by the TrinSoft Dynamics GP Team

You may want to have a report that uses one formula for certain rows, and another formula for other rows, but have it show in the same column in the report.

 

1.       Create a new column next to the existing column that already had the original formula.

a.       Make the Column Type = CALC

b.       Put Formula in

c.       Change Print Control = NP

d.       Make a note of the column Letter

 

Management Reporter

 

2.       In the Row Definition, go to the rows that need to be set to the different formula

a.       For each row with a different formula, insert a row underneath it.

b.       Change the original Row Print Control = NP

c.       Make the Format code of the new Row = CAL

d.       In the Related Formulas Cell, you will need to use Column Replacement to set which column to use for pulling the formula.

                                                               i.      In this example, I want Column A to remain the same so A=A.100 (I use row 100 which is the original Row code)

                                                               ii.      I want Column B to show the formula from Column C so B=C.100 (again using the original row code)

 

Management Reporter

 

-          Note that I only used Column A & B in the related formulas cell, but you would need to add in all columns that are printing columns to this row if there were more. 

 

The result of this is the following report:

 

Management Reporter

 

-          You can see that only the Row code 115 for Cash – Operating Account shows, and it’s using the formula from Column C (B*2) for the amount.

-          The Row ‘Cash in Bank – Canada’ is unaffected and is using the normal value from Column B.

Search in All Title Contents
2019 Jan  24  5
2018 Dec  13  6
2018 Nov  38  7
2018 Oct  45  4
2018 Sep  36  3
2018 Aug  48  5
2018 Jul  19  5
2018 Jun  48  6
2018 May  33  5
2018 Apr  349  6
2018 Mar  80  7
2018 Feb  42  5
2018 Jan  106  5
2017 Dec  90  9
2017 Nov  40  6
2017 Oct  73  8
2017 Sep  31  5
2017 Aug  152  11
2017 Jul  165  9
2017 Jun  121  11
2017 May  246  10
2017 Apr  28  6
2017 Mar  307  9
2017 Feb  165  11
2017 Jan  425  11
2016 Dec  176  10
2016 Nov  150  12
2016 Oct  22  11
2016 Sep  32  15
2016 Aug  33  16
2016 Jul  28  11
2016 Jun  35  12
2016 May  31  20
2016 Apr  36  5
2016 Mar  21  10
2016 Feb  47  3
2016 Jan  6  4