hi all
in my model i have a field - YearQuarter_Num (year & Quarter number i.e 20191,20192,20184,20183)
created a variable as below :
=Year(quartername (vMaxCreationDate, -1, 1 ))&Ceil(Num(Month(Date(quartername (vMaxCreationDate, -1, 1 ))),'00')/3)
vCreationQuarter4:
=Year(quartername (vMaxCreationDate, -4, 1 ))&Ceil(Num(Month(Date(quartername (vMaxCreationDate, -4, 1 ))),'00')/3)
in the chart the expression is :
sum({<PROBABILITY_Name=,ISCLOSED-={'N'},Sales_In_Out=,Sales_Source=, OppCreateQuarter_Num={'=$(vCreationQuarter4)'} >}TOTAL_AMOUNT)
or
sum({<PROBABILITY_Name=,ISCLOSED-={'N'},Sales_In_Out=,Sales_Source=, OppCreateQuarter_Num={'$(vCreationQuarter4)'} >}TOTAL_AMOUNT)
but both dosent retrieve the correct value
any ideas on how to resolve this or any other way to achieve quarter in set analysis ?
advanced thanks