topic Re: Obtain the latest Year - Sum Quantity Sold in App Development

Obtain the latest Year - Sum Quantity Sold

jerryr125 — Fri, 27 Nov 2020 14:29:49 GMT

Hi - I am trying to create a variable that does the following:

Data contains Sales Date for the past four years (2016 - 2019) and the quantity sold
I would like have a variable which calculates the sum of the quantity sold for the most recent year (hence 2019)

Table fields:

SalesDate

QuantitySold

Variable:

vYearMaxQuantitySold:

=Sum({$<[SalesDate.autoCalendar.Year] = {$(=max([SalesDate.autoCalendar.Year]))}>}[QuantitySold])

I try the formula above - does not work - any thoughts ? Jerry

Re: Obtain the latest Year - Sum Quantity Sold

Anonymous — Fri, 27 Nov 2020 15:13:45 GMT

Variable:

vYearMaxQuantitySold =max([SalesDate.autoCalendar.Year])

=Sum({$<[SalesDate.autoCalendar.Year] = {$(vYearMaxQuantitySold)}>}[QuantitySold])

Re: Obtain the latest Year - Sum Quantity Sold

MayilVahanan — Fri, 27 Nov 2020 15:38:04 GMT

Hi @jerryr125

Try like this

vYearMaxQuantitySold

Sum({$<[SalesDate.autoCalendar.Year] = {$(=max([SalesDate.autoCalendar.Year]))}>}[QuantitySold])

And use in the chart like $(vYearMaxQuantitySold)

In the variable declaration, don't use = sign. Then it calculated the value n store in the variable. So if u use the variable in the chart, result might be wrong.