Hi All -
I have a small report with a table.
Column A has Product, Column B has Month, Column C has Defects and Column D has (Defects + sum(distinct Brand Total)
We are doing Rsum(Column c) i.e., Defects and it is populating fine for all the months. If we are having nulls in any months the top months value is repeating which is correct in case of Rsum().
But for column d (Defects + Sum(distinct Brand Total), the rsum() is printing to the only values there is no data and it is not repeating for the blank values.
Because of addition in the Rsum() is it not working?
Can you please help?
| Product | Month | Defects(rsum(defectnumber) | Defect Count+Brand Total (rsum(defectnumber + sum(distinct BrandTotal) Brand Total will be distinct to all months for a product
|
|---|
| ABC | JAN | 0 | |
| ABC | FEB | 0 | |
| ABC | March | 0 | |
| ABC | APR | 11 | 12 (rsum(defect number) = 11 + Sum(distinct Brand Total) = 1) |
| ABC | MAY | 12 | 13 (rsum(defect number) = 12 + Sum(distinct Brand Total) = 1) |
| ABC | JUN | 14 | 15 (rsum(defect number) = 14 + Sum(distinct Brand Total) = 1) |
| ABC | JUL | 101 | 102( (rsum(defect number) = 101 + Sum(distinct Brand Total) = 1) |
| ABC | AUG | 101 | I need to repeat the 101 upto December month for Product ABC |
| ABC | SEP | 101 | |
| ABC | OCT | 101 | |
| ABC | NOV | 101 | |
| ABC | DEC | 101 | |
| | | |