Skip to Main Content

Analytics Software

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

User_UD1AZFeb 3 2022

IfThen formula with Period Number.pngTrying 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.