Aggregated Range Sum in the script

[Gaelledt1]

Hello everyone,

I have this expression in a chart. I would like to put it in the script, but I do not know what to do.

I have a product table with Product part number, Shipped Flag, Shipped Qty and Shipped date. In the chart I use the following expression:

AGGR(
             RANGESUM(ABOVE(

            SUM({< ShipFlag={1},

                           ShipDate={">=$(=MonthStart(Addmonths(TODAY(),-6))) < $(=MonthStart(Today()))"}
                           >}ShippedQty),0,RowNo()))
            /
          SUM({< ShipFlag={1},
                          ShipDate={">=$(=MonthStart(Addmonths(TODAY(),-6))) < $(=MonthStart(Today()))"}
                         >}TOTAL ShippedQty)
,
(PartNum,(=SUM({< ShipFlag={1},
                                      ShipDate={">=$(=MonthStart(Addmonths(TODAY(),-6))) < $(=MonthStart(Today()))"}
                                        >}OurStockShippedQty),DESC)))

I tried the following:

Table1:
LOAD

PartNum
,SUM(ShippedQty) AS PartSum

Resident ProductTable
Where ShipFlag = 1
And ShipDate >= MonthStart(Addmonths(TODAY(),-6))
And ShipDate < MonthStart(Today())
Group by PartNum
;

Table2:
LOAD *

,Rangesum(SUM(PartSum), Peek(PartSum)) AS PartTotalSum

Resident Table1;
Drop Table Table1;

Table3:
LOAD *,

PartSum/PartTotalSum AS Percentage

RESIDENT Table2;

DROP TABLE Table2;

The loading process is failing because of "invalid expression".

Your help would be much appreciated.

Thank you very much!