Set Analysis Comparison

[#1]

Hi All,

I have a problem i am trying to solve.

I would want to create an analysis to show the movement of status from month to month.

Example, when i select March, the expression will compare:

(P->N MOVEMENT)= (current selection's month, status = N) compared with (current selection month-1, status = P) then sum(outstanding_balance).

same goes for tracking movement from those status which is N moving to P in the current month N->P Movement.

In set analysis, how do i combine a set selection with a condition inside like above?

[Anonymous]

Johnny,

See if this info is helpful:

Selected Month with status N:
sum({$<status={'N'}>} outstanding_balance)

Selected Month with status P:
sum({$<status={'P'}>} outstanding_balance)

Prev with status N:
sum({$<Month={"S(=formula for prev month)"}, status={'N'}>} outstanding_balance)

Prev with status P:
sum({$<Month={"S(=formula for prev month)"}, status={'P'}>} outstanding_balance)

What is the "formula for prev month" in your case, I can't tell for sure - it depends on how you define Month in your data. For example, if month is defined as monthstart(Date), then the previous month will be monthstart(Date,-1)