How to calculate week for fiscal month in Spotfire 6.

Hi All, 

How to calculate week for fiscal month in Spotfire 6.0? My fiscal year starts from April 2013. First week of April is 14 in Number where as I want to assign it Week 1 and so on. I am successfully able to create fiscal year, fiscal Quarter, Fiscal Month with the help of function:

 FiscalBinByDateTime([Date],"Year.Quarter.Month",0)

Please help me calculating Fiscal week.

Regards,

Abdul Rehman

(2) Answers

Login