Advanced AGGR with Nested If

[#1]

The below expression at the line level returns the desired outcome. Unfortunately when used in the pivot table the column totals are incorrect. Is there a way to use an if statement like below in the AGGR expression?

=if((not isnull(Order__c.Ship_Date__c)) and Booked_on_AS400_a  <>'' and Rev_Rec_a > Today(),sum(Total_Price_a))

Thanx

[johnw · Accepted solution]

I'd expect you to be able to use just about any expression in an aggr to get a column total.  The general form is this:

sum(aggr(YourCurrentExpression,YourFirstDimension,YourSecondDimension,etc))