Excluding duplicates in a SUM

[#1]

Hi all,

I have a dataset which returns projects and programmes from our project management system.

sometimes a project will be within 2 levels of programs

as a result if I select the top level in my QVW, it will sum up multiple instances of a project.

how can I tell it to SUM by  distinct project code

my current expression is:

SUM(BUDGET_DAYS)

I need it by distinct PROJECT_CODE

Thanks in advance,

Matt

[#2 · Accepted solution]

This might work. Can you give it a try?

sum(aggr(SUM(Distinct BUDGET_DAYS), PROJECT_CODE))

Kiran.

[#3]

Seems to do the job very nicely thanks!!

Matt