partial sum showing zero

[sajad_manzoor]

Hello Gurus,

I am using following expression in pivot chart

"IF( EstimatedEndDate>= vStartDate and EstimatedEndDate <= vEndDate ,sum([Milestone Revenue in INR (TR)]),0)"

but the partial sums are showing 0

Please suggest.

Also , how can i write the same expression using set analysis...

[tresesco]

Change the total mode to Sum of rows and check

[sajad_manzoor]

Hi Tresesco,

this works only in straight table ,but when i use pivot chart, even no partial sum row is shown,

the partial sum property is checked for EstimatedEnd

[tresesco]

In the presentation tab 'Show Partial Sums' is there, you have to check/tick.

[sajad_manzoor]

'Show Partial Sums' check box is checked

[tresesco]

It is possibly because of you are using a calculated dimension or an expression which is complex. Please post a sample.

[Anonymous]

Hi,

1. use a text box object paste / write your expression there see is is showing 0 there if yes then there is

    problem in your expression.

2.  if expression show values and does not show zero then go to presentation tab check whether you checked both

      dimension ie project code and estimated end date as partial sum.

regards,

anant

[spividori · Accepted solution]

Hi.

Try:

sum(IF( EstimatedEndDate>= vStartDate and EstimatedEndDate <= vEndDate ,[Milestone Revenue in INR (TR)]))

Regards.