Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have two dimensions
BMI YEAR
BMI WEEKNR
Expression sum(sales).
So when i select in box year 2014 i see the sum(sales) for each week.
I have a slider based on KPI Bruto (-10% , -5%, 0%, 5%, 10%)
Now i am looking for the formula that
shows the selected sum(sales) for the selected year minus 1 and then multiplied by the KPI Bruto.
Example
Week 10 Year selected 2014, sum(bruto) 100 shows point 100 for weeknr 10
other value should be sum(bruto) for week 10 for year 2013 multiplied by KPI Bruto
Please help me with the formula.
sum ({<Year_field={$(=Max(Year_field)-1)}>} sales) * KPI_bruto_variable
You must know
Y Ax is: BRUTO amount number
x As is: weeknr (1 to 52)
FORMULA: should be the bruto sum of the weeknr of the year before the selected year.
Send the reduced .qvw copy please, i cant understand why last comment didn't work.
i think it's a mix between number variables and alfanumeric values in database?!