4 Replies Latest reply: Nov 16, 2016 1:15 AM by Gysbert Wassenaar RSS

    Straight Table with value of 0, but showing the values when selected...

    Samuel Lin

      Hi all,

       

      I am experiencing something that's pretty difficult for me to solve, and I have thought this through over the weekend with no luck...

       

      pic1.PNG

       

      L18M...through L30D are all with the value of zero, with the expression:

      sum(Aggr(Max({<LineType={'Shipped', 'Returned'}>} ExtRevenue), OrderLineNumber))

      the same thing happens if I remove the Aggr function with the expression:

      sum({<LineType={'Shipped', 'Returned'}>} ExtRevenue)


      HOWEVER, if L18M is selected, the value will show up to be non-zero....


      has anyone experienced this also?

       

       

      Additional Information:

      orderDate_Segment2 is defined in the script:

       

      orderDate_Segment2:

      Load if((today() - [order date])  > 730, [OrderNumber]) as OrderNumber,

      'L24M+' as orderDate_Segment2

      Resident [AgilOneTransactionExport];

      Concatenate

      Load if((today() - [order date])  <= 730 , [OrderNumber]) as OrderNumber,

      'L24M' as orderDate_Segment2

      Resident [AgilOneTransactionExport];

      Concatenate

      Load if((today() - [order date])  <= 548 , [OrderNumber]) as OrderNumber,

      'L18M' as orderDate_Segment2

      Resident [AgilOneTransactionExport];

      Concatenate

      Load if((today() - [order date])  <= 365 , [OrderNumber]) as OrderNumber,

      'L12M' as orderDate_Segment2

      Resident [AgilOneTransactionExport];

      Concatenate

      Load if((today() - [order date])  <= 275 , [OrderNumber]) as OrderNumber,

      'L9M' as orderDate_Segment2

      Resident [AgilOneTransactionExport];

      Concatenate

      Load if((today() - [order date])  <= 185 , [OrderNumber]) as OrderNumber,

      'L6M' as orderDate_Segment2

      Resident [AgilOneTransactionExport];

      Concatenate

      Load if((today() - [order date])  <= 90 , [OrderNumber]) as OrderNumber,

      'L3M' as orderDate_Segment2

      Resident [AgilOneTransactionExport];

      Concatenate

      Load if((today() - [order date])  <= 30, [OrderNumber]) as OrderNumber,

      'L30D' as orderDate_Segment2

      Resident [AgilOneTransactionExport];