Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a report that has been working well with just "Master Account...", "StockCode" & "Name" as options in the pivot table. As soon as I added "SalesCategory" I found a strange issue that I cannot solve. Under the Rebates & Discounts column the total for "SalesCategory" is nil despite everything below is calculating fine.
The fields under E-Commerce and Gross sales have been blanked out for posting but are populated correctly with values. This includes the one rebates value that is blanked out too.
What could be causing this issue?
Thanks
How about if you try this
(Sum({$<CalDate = {">=$(=date(AddMonths(today(),-12)))<=$(=date(today()))"}>} -[Gross sales value] * Rebate))
+
(Sum({$<CalDate = {">=$(=date(AddMonths(today(),-12)))<=$(=date(today()))"}>} -[Gross sales value] * Discount))
What is your expression for Rebates & Discounts?
(Sum({$ < CalDate = {">=$(=date(AddMonths(today(),-12)))<=$(=date(today()))"} > }-[Gross sales value])*Rebate)
+
(Sum({$ < CalDate = {">=$(=date(AddMonths(today(),-12)))<=$(=date(today()))"} > }-[Gross sales value])*Discount)
How about if you try this
(Sum({$<CalDate = {">=$(=date(AddMonths(today(),-12)))<=$(=date(today()))"}>} -[Gross sales value] * Rebate))
+
(Sum({$<CalDate = {">=$(=date(AddMonths(today(),-12)))<=$(=date(today()))"}>} -[Gross sales value] * Discount))
That's solved it. Thank you for this solution.