Forum Stats

  • 3,872,499 Users
  • 2,266,434 Discussions


Financial Reporting Studio IFTHEN Statement where the true/false parameter is based on Period Number

Trying to create a report using the conditional formula of IfThen. The formula needs to be defined where the balance of that account (which is in the previous row) will be displayed if the Period Number is 1. If the Period Number is not 1, then place 0 in the cell. The Accounting Period dimension is defined at the column.

Help will be greatly appreciated.