Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
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.
sum(
if(
aggr(
sum(
{<
txtDescription12INDICATOR = {'AVC'},
dteEffectiveDate11 = {"<=$(vStartOfEndDate)>=$(vEndDatePrevMonth)"},
ExitTypeINDICATOR = {'-1'}
>}
numAmount + numAmountInt ),ClientID)
> 0 ,
numAmount + numAmountInt
, 0 )
)
Member | Location | Age | Sum of Contributions |
123 | SA | 28 | 100 |
234 | ZA | 29 | 50 |
556 | ZA | 30 | - |
291 | SA | 31 | 96 |
In a sentence: I want to check whether there are any amounts for specific criteria at a client level, and then display the amount that is applicable to that Member level, which is the lowest level.
I hope that I have explained this in enough detail.
James
May be try this
Sum({<ClientID = {"=Sum({<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vStartOfEndDate)>=$(vEndDatePrevMonth)]}, ExitTypeINDICATOR = {'-1'}>} numAmount + numAmountInt) > 0"}>} numAmount + numAmountInt)
May be try this
Sum({<ClientID = {"=Sum({<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vStartOfEndDate)>=$(vEndDatePrevMonth)]}, ExitTypeINDICATOR = {'-1'}>} numAmount + numAmountInt) > 0"}>} numAmount + numAmountInt)