Value not coming correct.

[renuka_sasikumar]

Hi,

I have one Pivot table and one list box(month).

I have given the condition in pivot table that its should give the details of max month.

But there are 4 expression i m getting the max details for 3 but for one i m not getting.

But wen select the month all the values are coming right.

Can anyone pls help me its urgent.

[Anonymous]

Hi,

Please can post the expression.

Regards

Neetha

[renuka_sasikumar]

=Count({$<PA000.Date_From={'>=$(vMonthStartDate)<=$(vMonthEndDate)'},fYear={'$(vMaxYear)'},fMonth={'$(=Max(fMonth))'}>}DISTINCT OnRoll)

[Anonymous]

Hi,

What's the result you are expecting and what's the result?

Regards

Neetha

[renjithpl]

What are the calendar fileds you have ?

Try to nullify these fields and test it.

Eg.

=Count({$<PA000.Date_From={'>=$(vMonthStartDate)<=$(vMonthEndDate)'},fYear={'$(vMaxYear)'},fMonth={'$(=Max(fMonth))'}, Test_Quarter=, Test_Month=, Test_Week=>}DISTINCT OnRoll)

Please post a sample if possible.

cheers

Ren

[#6]

Hi Renuka

post all the 4 expression

[arulsettu]

try this

=Count({$<PA000.Date_From={">=$(=vMonthStartDate)<=$(=vMonthEndDate)"},fYear={"$(=vMaxYear)"},fMonth={"$(=Max(fMonth))"}>}DISTINCT OnRoll)