how to use in calculated dimension

[vikasmahajan]

Dear All,

I have following formula in my set analysis for calculating bucket for >=271 but gives wrong result ,

=SUM(aggr(if((vDateForAgeing - Max({$<StockInOutIndicator={1}>}PostingDate) >=271),

          (Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<=$(=(Max(PostingDate)))"}>} Inv_Val))

          )     ,

          Item_Code,Item_Name,[Lot No_],Location_Code))/100000

So I want to use Max({$<StockInOutIndicator={1}>}PostingDate)  in Calculated dimension please can anybody suggest how to use in calculated dimension.

Thanks in adv

Vikas

[tresesco]

try expanding your variable with '$' symbol, like $(vDateForAgeing). If that doesn't help, try to share your sample qvw.