Forum Discussion
Add Sum on column based on customer_id which cannot be used as a Group in Tablix
Hello,
I have a requirement where i want to check the number of customer who have transaction amt greater then 0, As Customer is a detail row it cannot be used in the tablix as i just need the number of customer's with positive transaction,
| famillie | # customer with positve transaction |
| A | 10 |
| B | 12 |
| C | 13 |
for example For famillie A there are 10 Customers with different transaction as positive as well as negative but their sum is positive.
i am trying to use an expression as
=Sum(IIf(Sum(Fields!CAAnne.Value,Fields!CUSTOMER_ID.Value)>0,1,nothing))
This gives me error as it is not in scope.
I hope i am able to explain my situation, please let me know if you have further queries.
Regards,
Arif
5 Replies
Hi Anonymous ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin YuHello,
for a product family there are N customers who would have bought the product, There could be negative transaction as well. so for a customer who has 2 trnasction one is positive "10" and other is negative "(-20)" and if i sum them it would be -10, so i just want to count the distinct customer who has positive transaction after sum.
As my report tablix is at Product family level i cannot add customer as it very detail data, so i would like to have acondition to check the sum of Amount at customer and check if it is greater then 0 and if it greater then 0 then include the customer in the count.