We are creating a cashflow statement in HFR. The text on some of the report lines needs to change dynamically with the results in a 2nd grid. In other words, if AR increases between this year and last, it need to say "increase in AR" and visa vera.
Is there a way to do this? Here is a picture:
| We need the TEXT to change in the report based on cells in grid 2 |
| Grid 1 | | | | | | Grid 2 | | | FY 18 | FY 17 | change |
| Variable 1 | Variable 2 | Description | | | | | | | |
| Increase | Decrease | | in accounts receivable | Account Receivable | | 150 | 100 | 50 |
| Increase | Decrease | | in accrued interest | | Accrued Interest | | 70 | 80 | -10 |
| | | | | | | | | | | | |
| | | | | | |
| Grid 2 $50 accounts receivable increase report line Text should read: |
| Increase in account receivable | | | |
| | | | | | |
| Grid 2 <$10> accrued interest decrease report line Text should read: |
| Decrease in accrued interest | | | |