Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need some help with my set analysis expression.
I am trying to populate the beginning AR Balance for the month with the ending AR Balance for the prior month.
Below is my set expression.
Sum({$<[posting_date.autoCalendar.Date]={"$=addmonths([posting_date.autoCalendar.Date],-1)"}, BALANCE_TYPE={"DEBIT_BALANCE"}>} [AR BALANCE])
What is your expression for Ending Gross AR Balance? I am assuming that Year-Month is a dimension and here and Description is a synthetic dimension or is it a dimension also?
The expression for Ending Gross AR Balance is
sum({<BALANCE_TYPE={"DEBIT_BALANCE"}>} [AR BALANCE])
The Description Dimension = [posting_date.autoCalendar.YearMonth]
Try this
Before(Sum({<BALANCE_TYPE = {"DEBIT_BALANCE"}>} [AR BALANCE]))
That does not work for me.
Would you be able to share a mocked up version of your app where we can see the issue?
I do not and I want to make sure if a prior month is deselected as a filter it does not affect the calculation.
@rnguyen2 wrote:I do not and I want to make sure if a prior month is deselected as a filter it does not affect the calculation.
You do not what?
I don't have a mocked version I can share.
Can you share your app? I mean it would be difficult to know what might be going on without seeing what you have