Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Members
how do i find qurter analysis
i want pre qtr(jul-sep) and curr(oct-dec) comparision
{${currentquarter}-1}"<=previous(quarter)>"}
hope it helps you
Hi
u can get the Current quarter name through below expression
=QuarterName(today())
u can get the Previous quarter name through below expression
=QuarterName(QuarterName(Today())-1)
So u can use this like below in comparision
=if(QuarterName(QuarterName(Today())-1)<QuarterName(Today()),'True','False')
hope it helps you
~Kabilan K
hai working fine
same way prev qtr end require jul-sep
Hi
Below expression to get the Quarterend Date for Previous Quarter.
=
QuarterEnd(QuarterName(Today())-1)~Kabilan K
Thanks for keeping reply
i want value between pre qrt start and pre qrt end
Hi U can write a expression like below
Sum({$<Datefield=">=$(=QuarterStart(QuarterName(Today())-1))
<=$(=QuarterEnd(QuarterName(Today())-1))">}Sales)
I hope it helps U... ![]()
~Kabilan K