Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi freinds,
i have an issue in current-quarter and previous year quarter comparisions.so pls help me out.
i have an fieds Financialyear,FinancialMonth, Datefiled.
Hi.
Please upload ur application .i help to u
Hi perumal ,
application size is too large yar
Can u give me a sample application
Can you please give sample data to understand your requirement??
calculate quarter
in script
ceil(Month(FinancialMonth)/3) as Finquarter
in Expressions
Current qurter:
sum({<Finquarter={$(=max(
{<Financialyear={$(=Max(Financialyear))}>}Finquarter))}>}Amount)
Previous Quarter:
sum({<Finquarter={$(=max(
{<Financialyear={$(=Max(Financialyear))}>}Finquarter)-1)}>}Amount)
Hope this helps
Hi Manideep,
if u have sample one send me the appication yar
Hi luminary,
if u have sample one provide me the application .
Hi,
only load 10000 record and upload qvw application .