Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate the last year Quarter sale?

Hi....

Can any one help me to calculate last year quarter sale as I am using

-----------------------------------------------

-1*(SUM({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,[PostingDate]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]))"}>}[GD_Amount]))/100000

)

------------------------------------------------

this expression for calculating current year quarter sale.

Thanks.....

0 Replies