How to use this expression in calculate dimension

[vikasmahajan]

Dear All,

I have following expression & I want to use this in calculated dimension how do I use in calculated dimension

=(SUM({<FinancialYear=,Quarter=,MonthName=>} AGGR(if( (Date(vDateForAgeing)-if(isnull(Date([DUE_DATE])),1,Date([DUE_DATE])) <=30),SUM({$<FinancialYear=,Quarter=,MonthName=,[Posting Date] ={"<=$(=MonthEnd(Max([Posting Date])))"}>}[Net Outstanding])),DOC_NO,Customer,Location))

/100000)

Vikas

[Gysbert_Wassenaar]

You need to put an aggr around it so it calculates sum values over one or more dimensions.

[tresesco]

Do you really want a numeric value to be used as a dimension?

[vikasmahajan]

Can you modify and send me how ?

Vikas

[Gysbert_Wassenaar]

No, because I don't know which dimensions you want to aggregate the sums over. You already have an aggr function in that expression so you should know how aggr works.

[vikasmahajan]

DOC_NO,Customer,Location  this are my dims used for aggr

[Gysbert_Wassenaar]

I really have no idea what you're trying to do. You can try removing the outer sum from your expression or adding an aggr around it that uses those dimensions again. The latter option doesn't make sense to me. Maybe you should simply try both options and see if one does what you want.

[vikasmahajan]

I want to display  0-30 in bucket  and rest in expression

[tresesco]

Could you post your sample app with sample data?

[vikasmahajan]

application can not share thanks.

Vikas