Pivot table expression format diffrence

Tue, 13 Aug 2013 08:43:39 GMT

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

Re: Pivot table expression format diffrence

tresB — Tue, 13 Aug 2013 08:57:38 GMT

Have a look at this discussion