set analysis

[#1]

Hi everyone;

How i can get the sales from last years with the next expression that show the sales actually year:

=

sum(if(CURRENCY_FILTRO='USD',(((ventapesos)/1000)/rate_usd),(ventapesos)/1000))

regards!!!

[nirav_bhimani · Accepted solution]

Hi,

Try the following expressions

Current Year Sales: 2013

sum({<FinancialYear = {"$(=Max(FinancialYear))"}>}Sales)

Last Year Sales:  2012

Sum({<FinancialYear = {"$(=Max(FinancialYear)-1)"}>}Sales)

Last  to Last Year Sales: 2011

Sum({<FinancialYear = {"$(=Max(FinancialYear)-2)"}>}Sales)

Regards,

Nirav Bhimani

[#3]

Thanks Nirav for your help but i neet too the dimention called CURRENCY_FILTRO with the IF.

regards!!

[nirav_bhimani]

Hi,

You want to use If condition then

(if(CURRENCY_FILTRO='USD',

((sum({<FinancialYear = {"$(=Max(FinancialYear))"}>}ventapesos)/1000)/rate_usd) ,

(sum({<FinancialYear = {"$(=Max(FinancialYear))"}>}ventapesos)/1000)

Regards,

Nirav Bhimani

[Sokkorn]

Hi,

You can try this:

Last year sale:

=If([CURRENCY_FILTRO]='USD',

    Sum({$<[SaleYear] = {$(=Max([SaleYear])-1)}>} (ventapesos/1000)/rate_usd)

    Sum({$<[SaleYear] = {$(=Max([SaleYear])-1)}>} ventapesos/1000)

)

Current year sale:

=If([CURRENCY_FILTRO]='USD',

    Sum({$<[SaleYear] = {$(=Max([SaleYear]))}>} (ventapesos/1000)/rate_usd)

    Sum({$<[SaleYear] = {$(=Max([SaleYear]))}>} ventapesos/1000)

)

Above expression just a clue for you to get start.

Regards,

Sokkorn

[#6]

thanks everyone i will try today this responses i was in in labor board

Regards!!

[#7]

Thanks very much !!! work it !!!