Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try adding Sum(Aggr(YourExpression, ChartDimensions)) to get the correct total.
Try adding Sum(Aggr(YourExpression, ChartDimensions)) to get the correct total.