topic Re: Define the expression in App Development

Define the expression

prasad333 — Sun, 05 Nov 2017 14:08:48 GMT

Hi,

I was going through a dashboard where I found a slider object showing comparison value for previous year and current year but as an entrant I couldn't understand the set expression. Can anyone please define this

=year(AddYears(maxOrderDate,-1)) & ' vs. ' & year(maxOrderDate) & ' ' & Only({<No={59}>} [$(=vDataLanguage)]) & ' = ' & num(( sum( {<Year={$(=Max(Year))}>} SalesAmount) - sum({<Year={$(=Max(Year)-1)}>} SalesAmount))/sum( {<Year={$(=Max(Year)-1)}>} SalesAmount), '#.#%')

Regards,

KHARANSU

Re: Define the expression

maxgro — Sun, 05 Nov 2017 18:34:00 GMT

year(AddYears(maxOrderDate,-1)) & ' vs. ' & year(maxOrderDate)

if maxOrderDate is 2017

2016 vs 2017

' ' & Only({<No={59}>} [$(=vDataLanguage)])

don't know, it depends on field No and variable vDataLanguage

' = ' & num(( sum( {<Year={$(=Max(Year))}>} SalesAmount) - sum({<Year={$(=Max(Year)-1)}>} SalesAmount))

sum( {<Year={$(=Max(Year)-1)}>} SalesAmount), '#.#%')

if max year is 2017 (sales amount 2017 - sales amount 2016) / sales amount 2016

% change in sales amount

Re: Define the expression

prasad333 — Mon, 06 Nov 2017 18:43:53 GMT

Thank You Massimo. Thanks for the detailed explanation and yes there are different languages, so they have used variable.