Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find the enclosed QVW file ,associated spreadsheet and document file(screenshot) what i want within the application.
I am requesting you please help me in that regards.
When does your fiscal year starts?
Best,
S
From january
Please help
Hi Suman,
why do you use 'Q' & if(month(D)<4,4,floor(month(D)/3.1)) as @_FinQuarter, that's why you get the Quarter as 'Q4'.
Financial Quarter for February is 'Q4'. if you want your result as Q1, just use 'Q' & ceil(num(M) / 4) AS Quarter,
or use like the below
IF (Mixmatch(LEFT(Monthname(D),3),'Jan','Feb','Mar')>0,'Q1')
AS @_FinQuarter .
In the report word document file i mentioned my requirement.
Based on the attached document file i want to change my application.
Please help