To Fiscal Month

To convert a regular calendar month to a month based on the fiscal year, use To Fiscal Month function in the Query section.

  1. In Query section, select Query menu, select Add Computed Item and name the new data item in the dialog box.
  2. In the panel, type To_Fiscal_Month followed by a left parenthesis
  3. Next, use the Reference button to select Month_Cd data element from the table and type a right paren.
  4. Click OK in the Item dialog box.
  5. To review/modify the computed item double click on the item name on the Request Line.

Last updated: October 15, 2013

Last updated: October 15, 2013