delivery

[fmazzarelli]

hi community,

I have several years online . What is the formula to extract all kilograms shipped separately in 2011, 2012, 2013, 2014 and in 2015 ?

[fmazzarelli]

Hi Community,

i post again my needs.

I have to sum a value if a condition is verified

That means;

sum(data)

if year(today()) = 'vYear (input variable)

Example:

sum(Kg) if 2015 = 2015 (input variable)

In Excel I use the function sumif

[igdrazil]

So I was nearly correct, just replace the '2010' in this formula: sum({<Year = {'2010'}>}KG) with your Variable, so you'll get the sum of KG for the year that is defined in your Variable.

Regards

Chris

[ogster1974]

Lets try to break this down from your various posts.

I think you want to display the result as a KPI visualisation.

The input parameter to the KPI is a year or multiple years of Kg data?

If its one year you can use the qsVariable approach I've given you before to create a drop down of years and populate a variable for use in your measure.

Sum({<Year = $(vYear)>}kg)

For multiple years a simple SUM(Kg) should suffice based on the data example you published as users selection/de selection of years will drive the total Kg.