Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
do not use = before your expression.
Just start with If condition.
You might need to add Sum(Aggr()) function
Sum(Aggr(
YourExpressionForWin, YourChartDimensions))
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)
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))
Thanks for your helpfullness and pation.
Håkan