To convert a regular calendar month to a month based on the fiscal year, use To Fiscal Month function in the Query section.
- In Query section, select Query menu, select Add Computed Item and name the new data item in the dialog box.
- In the panel, type To_Fiscal_Month followed by a left parenthesis
- Next, use the Reference button to select Month_Cd data element from the table and type a right paren.
- Click OK in the Item dialog box.
- To review/modify the computed item double click on the item name on the Request Line.
Last updated: October 15, 2013