Help with Aggr () not working

[qvqfqlik]

I am trying to aggregate the total value of the count result as below. but this is not happening

Sum(Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}>} DISTINCT BILLTOCUSTEDP),OFFERNUM))

I am trying to aggregate the same offernumber

below is before aggregating:

below is after aggregating, the total should be 19 , but it still shows as 18

[qvqfqlik]

If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() = '6', Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}

>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))

it is not aggregating as below

[sunny_talwar]

Do you mind sharing a sample of your app?

Preparing examples for Upload - Reduction and Data Scrambling

You can try this:

If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 6, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}

>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))

or

If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 5, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}

>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))

[qvqfqlik]

I have reduced the data and attached the app file to the original post.

Thanks a lot Sunny , I tried  Dimensionalitiy() <=5 and also <=6 , but it didnot work.

[sunny_talwar]

This seems to be working, isn't it?

If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 5, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED},

      ORDER_YEAR *= {">=$(vStartYear)"},

      REPORTING_YEAR=,

      REPORTING_MONTH =,

      REPORTING_QUARTER=,

      REPORTING_DAY=,

      REPORTING_DATE=,

      SHIP_YEAR=,

      SHIP_MONTH=,

      SHIP_QUARTER=,

      SHIP_DAY=,

      SHIPDATE=

>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))

[qvqfqlik]

Not sure, for some reason in my app its showing 0. please help me

[sunny_talwar]

‌Did you try to open the app I attached? you don't see 19 for total in that one also?

[qvqfqlik]

I opened the app you've attached, I think you have attached my original file. can you please post the correct one with your changes

[qvqfqlik]

Can you please attach your file changes.

I used the same , but still seeing 0

If(Len(Trim([FULLOFFERNAME])) > 0 or Dimensionality() <= 5, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED},

      ORDER_YEAR *= {">=$(vStartYear)"},

      REPORTING_YEAR=,

      REPORTING_MONTH =,

      REPORTING_QUARTER=,

      REPORTING_DAY=,

      REPORTING_DATE=,

      SHIP_YEAR=,

      SHIP_MONTH=,

      SHIP_QUARTER=,

      SHIP_DAY=,

      SHIPDATE=

>} DISTINCT BILLTOCUSTEDP),OFFERNUM,FULLOFFERNAME)))

[qvqfqlik]

In your app file I see Dimensionality()='6', and its not aggregating, and the total is 0

[sunny_talwar]

Attaching again