Component Solution Services REC02F Manual de usuario descargar pdf (Pagina 23)

Tips Recipes Brio 2002

(Creating Fiscal Year based information continued)

4) This sequence of steps will produce a Date_Month column that displays the month names

in short (3 letter) form. To display the full month name, right-click on the

Date_Ordered_Month and select Number from the speed menu. In the number format

dialog box that appears, select the Custom category and type in the following format

formula:

“mmmm”

This display format (4 m’s) will show the full month name without displaying the year or

day.

5) To display monthly items in proper fiscal year order, you will also need to create a

Fiscal_Month_Number column. To add a Fiscal_Month_Number column, create a new

Computed Item with that name. Define the formula to be:

Decode(ToChar ( Date_Ordered, "mmm" ), 'Jan',10, 'Feb',11,

'Mar',12, 'Apr',1, 'May',2, 'Jun',3, 'Jul',4, 'Aug',5,

'Sep',6, 'Oct',7, 'Nov',8, 'Dec',9,0)

For fiscal years that start on a date other than April 1, adjust the numbers in the decode

function accordingly.

1 2 ... 18 19 20 21 22 23 24 25 26 27 28 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 23