Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i wrote the quarter function : 'Q' & Ceil (Month(Date)/3) AS Quarter,
But It SHowed me :
I Don't want to see the Q,
i need Only Q1, Q2, Q3 and Q4.
Thank Guys.
It seems correct can you share app or you can do some change in the load script
Load
If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter
From Source;
Regards
Anand
Instead of using FieldName Quarter in List box use expression and use below
=if(Len(Quarter)>1, Quarter)
It seems correct can you share app or you can do some change in the load script
Load
If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter
From Source;
Regards
Anand
where i have to write this expression ?
In the Calender where you are using Quarter function and derieving the Quarter field, and using in the ListBox image, just use the expression
If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter
Thanks