Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need help on creating Financial year.For example I have field DOJ.
To that
i want Year view-- 2014-2015 and 2015-2016
Month view Aprl to Mar and also Q1,Q2,Q3 Q4.
Find below Sample dATA.
Its Urgent>>>>>>>>
Hi Nagarjuna
Do you want Financial year for joining or years from joining till today? Please clarify it.
If you just want Financial Year & Quarter of Joining you can use
- YearName(DOJ, 0, 4) as FinYear
- If(Num(Month(DOJ))>3, Ceil(Num(Month(DOJ))/3),4) as FinQtrNum
Let me know if this helps to resolve your issue.
--
Regards,
Prashant P Baste
Try to use this in script.
Dual(Year-1 &'-'& Year, Year) as FinYear
Hope it will help.
CAn u show that using Sample data
I m not geting that
hi,
It will help u
lo:
LOAD DOJ,
YearName(DOJ, 0, 4) as FinYear,
If(Num(Month(DOJ))>3,'Q' & Ceil(Num(Month(DOJ))/3),4) as FinQtrNum
FROM
(ooxml, embedded labels, table is Sheet1);
Thank u,
balaji
Hi,
try this.
FiscalCalendar:
LOAD
*,
Dual('Q' & Ceil((Mod(Month(Date) - 4, 12)+1 )/3), Ceil((Mod(Month(Date) - 4, 12)+1 )/3)) AS FiscalQtr,
Dual(Text(Date(MonthEnd(Date), 'MMM')), (Mod(Month(Date) - 4, 12)+1 )) AS FiscalMonthName,
Year(Date) AS Year,
Month(Date) AS Month,
Date(MonthEnd(Date), 'MMM') AS MonthName,
Dual('Q' & Ceil(Month(Date)/3), Ceil(Month(Date)/3)) AS Quarter,
Mod(Month(Date) - 4, 12)+1 AS FiscalMonth,
YearName(Date, 0, 4) AS FiscalYear
FROM
SampleData.xlsx
(ooxml, embedded labels, table is Sheet1);
Hi,
use this code it will help u to complete u r task
SET vstartmonth = 4;
LOAD DOJ,
'Q' & left(Ceil(DOJ/3),1) as quarter,
YearName(DOJ, 0, 4) as Year
FROM
(ooxml, embedded labels, table is Sheet1);
Thank you,
balaji.k