Dear All,
I am facing the issue while calculating expression using valulist & above function.
I have pivot table
1st dimension : ValueList('30+ AR Delinquency','60+ AR Delinquency')
2nd dimension : Month
Expression :
// .................................30+ Bucket
if(ValueList('30+ AR Delinquency','60+ AR Delinquency')='30+ AR Delinquency',
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),3),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'60-89'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),4),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'90-119'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),5),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'120-149'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),6),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'150-179'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),7),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'180-209'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),8),Daily_Sales_Fin_Month_Name),'##00.00'))
),
// .................................60+ Bucket
if(ValueList('30+ AR Delinquency','60+ AR Delinquency')='60+ AR Delinquency',
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'60-89'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),4),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'90-119'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),5),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'120-149'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),6),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'150-179'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'>}BookSize_Debtor_AR_POS)/vCr_Denom),7),Daily_Sales_Fin_Month_Name),'##00.00'))
)
+
(
rangesum(num(aggr((sum({<BookSize_Debtor_AR_DPD_Bucket ={'180-209'}>}BookSize_Debtor_AR_POS)/vCr_Denom),Daily_Sales_Fin_Month_Name),'##00.00')/
num(aggr(above((sum({<BookSize_Debtor_AR_DPD_Bucket ={'30-59','60-89','90-119','120-149','150-179','180-209','210+'}>}BookSize_Debtor_AR_POS)/vCr_Denom),8),Daily_Sales_Fin_Month_Name),'##00.00'))
)))
When I am using this expression I am getting the values for 30+ AR Delinquency but not for the 60+ AR Delinquency
but when i am taking single expression for 60+ AR Delinquency I am getting the values..
As I am combining valuelist condition I am not getting the values for 60+ AR Delinquency
I am not getting what is wrong with expression
