Aggr function set analysis VS if

[#1]

Hi there,

Can anyone explain whats the difference between these 2 expressions:

1) sum({<Confirmed={'1'}>}aggr((($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate]),ProjectCode,ConsultingMonth,Product,Sector))

and

2) sum(aggr(if(Confirmed=1,(($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate])),ProjectCode,ConsultingMonth,Product,Sector))

It seems my report does work only with the 2) expression even though i don't have any confirmed codes at all.

If I use the first expression I just get the total of the current selection and qlikview seems to ignore set analysis.

Kind Regards,