2 Replies Latest reply: Nov 26, 2010 4:07 AM by JurajChovan

# Why all columns are not summed?

hi friends,

SourceProjectData:

YMyProjectName,

YMyProjectStartDate,

YMyProjectEndDate,

YIDMyDeliverable,

YIDMyProjectDeliverable,

YMyDeliverableName,

YSourceHourTax,

YMyDeliverableStartDate,

YMyDeliverableEndDate,

YMyDeliverableTotalInvoice,

YMyDeliverableSource,

YMySourceUtilization,

YIDWorkingJob,

YWorkingDate,

YDurationOfWorking

Resident TempSourceProjectData;

from these data I build chart object (pivot table) where dimensions are:

YMyProjectName

YMyDeliverableName

YMyDeliverableSource

and expressions are:

=Div((Sum(YDurationOfWorking)/2),60)&'h:'&Mod((Sum(YDurationOfWorking)/2),60)&'m'

=((Sum(YDurationOfWorking)/2)/60)*YSourceHourTax

Note: first expression converts number of minutes to format HHh:mmm (eg.6h:30m)

and second calculates costs for source (eg.duration of work(=390min) * source hour tax(=13€) = 84,50€)

There is chart properties - dimensions:

and there is tab with expression (and formula for suspect expression):

now is my question is - why no all columns are summed??? (eg."working duration" is summed for all deliverables (please see following image), but "source working costs" column is summed only if exist just one value (if exist more values (please see "deliverable P01-01" on following image) sum value is not available):

any idea?

• ###### Why all columns are not summed?

Hi.

I guess it's because the YSourceHourTax is outside of the aggregation function... Try to use the whole expression inside another aggregation function and it'll work.

Regards,

Montal.

• ###### Why all columns are not summed?

very thanks, it is working.

right formula is following: Sum(((YDurationOfWorking/2)/60)*YSourceHourTax)