Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi.
Try:
sum(IF( EstimatedEndDate>= vStartDate and EstimatedEndDate <= vEndDate ,[Milestone Revenue in INR (TR)]))
Regards.
Change the total mode to Sum of rows and check
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
In the presentation tab 'Show Partial Sums' is there, you have to check/tick.
'Show Partial Sums' check box is checked
It is possibly because of you are using a calculated dimension or an expression which is complex. Please post a sample.
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
Hi.
Try:
sum(IF( EstimatedEndDate>= vStartDate and EstimatedEndDate <= vEndDate ,[Milestone Revenue in INR (TR)]))
Regards.