Set analysis gives correct figure in table. But when I add to a KPI I get zero?

[Ja123__]

Hi Guys

When I have my calculation in a table the row value is correct but the value for the total reflects 0, as well as when I add it to my KPI?

Am I missing something??

HIGHLIGHTED CALCULATION

Sum(
{
<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vEndDate)]}, blnRepeat = {'1'},dteTerminated11INDICATOR = {'-1'}, ExitTypeINDICATOR = {'-1'}>
+
<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vEndDate)]}, blnRepeat = {'1'},dteTerminated11 = {[>$(vEndDate)]}, ExitTypeINDICATOR = {'-1'}>
}

if(isnull(numAmount),0,numAmount)

)

*       

//Times by the number of months. Also if there is a shorter period between effective date and end date rather use that //than the overall DateDiff variable which just does the month differences between the two dates.

if(

min(
{
<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vEndDate)]}, blnRepeat = {'1'},dteTerminated11INDICATOR = {'-1'}, ExitTypeINDICATOR = {'-1'}>
+
<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vEndDate)]}, blnRepeat = {'1'},dteTerminated11 = {[>$(vEndDate)]}, ExitTypeINDICATOR = {'-1'}>
}

round((Date(Date#('$(vEndDate)','YYYY/MM/DD')) - Date(Date#(dteEffectiveDate11, 'YYYY/MM/DD'))) / 30.42))
<
$(vMonthDiff)
,
min(
{
<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vEndDate)]}, blnRepeat = {'1'},dteTerminated11INDICATOR = {'-1'}, ExitTypeINDICATOR = {'-1'}>
+
<txtDescription12INDICATOR = {'AVC'}, dteEffectiveDate11 = {[<=$(vEndDate)]}, blnRepeat = {'1'},dteTerminated11 = {[>$(vEndDate)]}, ExitTypeINDICATOR = {'-1'}>
}
round((Date(Date#('$(vEndDate)','YYYY/MM/DD')) - Date(Date#(dteEffectiveDate11, 'YYYY/MM/DD'))) / 30.42))
,
$(vMonthDiff)
)

vMonthDiff

=
round(
(Date(Date#('$(vEndDate)','YYYY/MM/DD')) - Date(Date#('$(vStartDate)','YYYY/MM/DD'))) / 30.42
)

I know the formula can be confusing but clearly I am missing why my totals are gone.

[sunny_talwar · Accepted solution]

Try adding Sum(Aggr(YourExpression, ChartDimensions)) to get the correct total.

[Ja123__]

Thanks Sunny!
Sum(Aggr(
COPY AND PASTE ABOVE SCRIPT
, MemberID , txtClientName , txtFirstname ,txtSurname ))

Did the job