Moving Totals to a variable

[#1]

Hello,

I have a fully working chart with two results, Wins and Lost. the values are correct and my problem is

that I would like to have the Total in an variable so I can uset it in an KPI-object .

The calculation for the Win is:

When I put this into a variable and show it in the KPI-object it shows 0.

kindly

Håkan

[MK9885]

do not use = before your expression.

Just start with If condition.

[sunny_talwar]

You might need to add Sum(Aggr()) function

Sum(Aggr(

YourExpressionForWin, YourChartDimensions))

[#4]

Good morning,

how shall I place aggr(), for each sum or one for the whole calculation?

=if ( Sum({$<$(vSetRolling12),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsG) and

Sum({$<$(vSetPreviousMonth),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) < $(vOmsGMonth) and

Sum({$<$(vSetMTD),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsGMonth) ,1,0)

[sunny_talwar · Accepted solution]

Just one for the whole calculation

Sum(Aggr(

If(Sum({$<$(vSetRolling12),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsG) and

Sum({$<$(vSetPreviousMonth),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) < $(vOmsGMonth) and

Sum({$<$(vSetMTD),[BudgetSegment]={"Glas"}>} $(vNettoFörs)) >= $(vOmsGMonth) ,1,0),

ChartDimensionHere))

[#6]

Thanks for your helpfullness and pation.

Håkan