Sum of members if overall client balance greater than 0. Aggr, IF, SUM and multiple conditions.
I have thought of an example to ask that I think will answer some other questions I have.
I have members, members belong to clients. I want to check if at a client level there have been any payments in the previous month along with a few other criteria that I include in the models set analysis.
I want to display this calculation on a member detail level but it doesn't look right to me...
This is the calculation that I'm using and I will make notes below it, maybe something stands out. Specifically the last amount that I want to be the result.