using formula in pivot table

[#1]

HI EXPERTS,

I HAVE THE FOLLOWING FORMULA FOR A PARTICULAR FIELD IN A PIVOT TABLE.

((Sum({< [CalendarDate] = {'>=$(=Date(vThisMonthStart))<=$(=Date(vMaxSalesDate))'} >} SPAMT)

/

((TGT_YEAR/12)*SRDAYS))

/

(Sum({<CalendarMonthYear={'$(vReview1MonthYear)'}>}SRDAYS), BRNO))

but if i use this in the table, i m getting null values.

Please help me in this regard

[MK_QSL]

((Sum({< CalendarMonthYear = , [CalendarDate] = {'>=$(=Date(vThisMonthStart))<=$(=Date(vMaxSalesDate))'} >} SPAMT)

/

((TGT_YEAR/12)*SRDAYS))

/

(Sum({<CalendarDate = , CalendarMonthYear={'$(vReview1MonthYear)'}>}SRDAYS), BRNO))

[#3]

hi Manish,

thanks for replying.

i tried this but its not working.

also its showing error near BRNO (next to comma)

[jonathandienst]

I expect your problem is in the TGT_YEAR and SRDAYS. These fields are not in an aggregation function and probably have more than one possible value, so they evaluate as NULL.

HTH

Jonathan

[PrashantSangle]

Hi,

(Sum({<CalendarMonthYear={'$(vReview1MonthYear)'}>}SRDAYS), BRNO))

what is logic behind writing , BRNO))

after Sum()
are you using any aggr()

Try writing each expression in 3 different text object.

Check which value giving you null.

Regards

[#6]

hi,

SRDAYS will vary for different branches.

i tried using aggr too.

but its not working