Set Analysis and AGGR

[frederickjones]

Hello all - 

I have a table with these fields: Debit Month Number, Year, Accounts and Base Accounts. Below is the output I am trying to derive for "Base Accounts". It should repeat the values from "Accounts" where "Debit Month Number" is equal to 0, for each respective year.

"Accounts" is this measure: count(distinct ACCOUNT_ID). 

Is there an easy way to do that in the front end without having to change any backend scripting? 

Thanks in advance. 

Debit Month Number	Year	Accounts	Base Accounts
0	2017	100	100
0	2018	150	150
0	2019	125	125
1	2017	75	100
1	2018	125	150
1	2019	100	125
2	2017	60	100
2	2018	115	150
2	2019	80	125
3	2017	55	100
3	2018	105	150
3	2019	70	125

[Sebastiaandb]

Easiest solution would be to use a IF statement i guess.
Something like:
IF([Debit Month Number] = 0, [Accounts], [Other number to use in case Debit Month is not equal to 0])