Pivot table expression format diffrence

[#1]

Hi everyone,

I have a pivot table sum that it does not show if i format my expresion in a specific way.

The sums show correctly at the 1st expression:

if( b.Year < SubField(vTODAY,'-',1),sum(b.QtyInvoiced),if(b.Month < SubField(vTODAY,'-',2),sum(b.QtyInvoiced),sum(b.ForecastQty)))

But do not show at the 2nd expression:

sum(if( b.Year < SubField(vTODAY,'-',1),b.QtyInvoiced,if(b.Month < SubField(vTODAY,'-',2),b.QtyInvoiced,b.ForecastQty)))

Can anyone enlighten me what is the diffrence between those two???as well as when to use one or another???

Regards

[tresesco]

Have a look at this discussion