Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What happens when you add Offer Name to your aggr?
Sum(Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}>} DISTINCT BILLTOCUSTEDP),OFFERNUM, [Offer Name]))
Below is when I include Offer name, its'nt still not aggregating
I am not sure what you mean? Do you not want to see the total as 19? What do you want to see?
Yes, when its aggregated, I want it to to be shown as 19 in a single row. Below , instead of 18 I want it to be 19
May be try this:
If(Len(Trim([Offer Name])) > 0, Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}>} DISTINCT BILLTOCUSTEDP),OFFERNUM, [Offer Name])))
Thanks Sunny , In that row , I got it as 19 , but in the Total row, I still see it as 0
Would you provide application to work on it? We may help you what was the wrong over there?
May be make sure of Dimensionality() here.... Check what you get for Dimensionality() in the total row and use or condition like this:
If(Len(Trim([Offer Name])) > 0 or Dimensionality() = '---', Sum(TOTAL <OFFERNUM>Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}>} DISTINCT BILLTOCUSTEDP),OFFERNUM, [Offer Name])))
Replace '---' with the number you find when you use Dimensionality() as an expression
I guess you deleted your comment, but this might still be useful to see....
Did you read my comment?
If you are still not sure, take a look here:
If this doesn't help, I would suggest you to share your app so that we can help you out