15 Replies Latest reply: Aug 16, 2013 5:28 AM by Yeo Poh sai

# U R G E N T - Set Analysis Help required

Dear All

I have following expression for calculating sales as per user selected month and year ,

I want to display same set of expression for last year as per user selected month and year  dynamically.

(SUM({\$<FiscalYear={\$(=max(FiscalYear))}>}[Sales Invoice Qty])

-

SUM({\$<FiscalYear={\$(=max(FiscalYear))}>}[Sales Return Qty])

)/1000

Vikas

• ###### Re: U R G E N T - Set Analysis Help required

Have you tried this?:

(SUM({\$<FiscalYear={\$(=(max(FiscalYear)-1))}>}[Sales Invoice Qty])

-

SUM({\$<FiscalYear={\$(=(max(FiscalYear)-1))}>}[Sales Return Qty])

)/1000

• ###### Re: U R G E N T - Set Analysis Help required

Hello

Thanks For Immediate reply I have try the same but unfortunately I am not getting results .

any idea ?

Vikas

• ###### Re: U R G E N T - Set Analysis Help required

Can a sample app be posted?

• ###### Re: U R G E N T - Set Analysis Help required

No  Application can be share.

• ###### Re: U R G E N T - Set Analysis Help required

Hi

Try like this

(SUM({1<FiscalYear={\$(=max(FiscalYear)-1)}>}[Sales Invoice Qty])

-

SUM({1<FiscalYear={\$(=max(FiscalYear)-1)}>}[Sales Return Qty])

)/1000

• ###### Re: U R G E N T - Set Analysis Help required

I think this will not work  Set analysis will ignore user selection dimension if we use 1 identifier.

sum({1} Sales) =>  Returns total sales within the application, disregarding selections but not

the dimension.

Thanks

Vikas

• ###### Re: U R G E N T - Set Analysis Help required

You can share your application without worring about data, look at this and this too.

• ###### Re: U R G E N T - Set Analysis Help required

Hi tres

i like the 2 link you posted. very useful info.

• ###### Re: U R G E N T - Set Analysis Help required

Hi,

Below expression will work.

(SUM({\$<FiscalYear={\$(=Max(FiscalYear)-1)}>} [Sales Invoice Qty])

-

SUM({\$<FiscalYear={\$(=Max(FiscalYear)-1)}>} [Sales Return Qty])

)/1000

Make sure that you don't have any data issues.

Also shouldn't get divide by zero error means SUM({\$<FiscalYear={\$(=Max(FiscalYear)-1)}>} [Sales Return Qty]) expression should result zero.

• ###### Re: U R G E N T - Set Analysis Help required

I tried and unfortunately it doesn't work.

• ###### Re: U R G E N T - Set Analysis Help required

IF user selects  Month and year then sales related to month and year should display vs last year same months and year sets.

Thanks

Vikas

• ###### Re: U R G E N T - Set Analysis Help required

Hi

Its work fine. When u select the fiscal year.

If u select fiscal year - 2013, its display 2013 value and 2012 value

For 2012 , there is no data, so it display zero.

• ###### Re: U R G E N T - Set Analysis Help required

Thanks I thing  you have not understand what exact I want

If user will select fin year 2013 and month  may & june I want to display  may+june sale (2013 ) vs  may+june(2012) I want to display,

Is there any solutiion ?

• ###### Re: U R G E N T - Set Analysis Help required

Vikas,

Expression should be:

SUM({\$<FinancialYear=,FiscalYear={\$(=(Max(FiscalYear)-1))}>} [Sales Invoice Qty])

PFA