U R G E N T - Set Analysis Help required

[vikasmahajan]

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

Thanks in advance

Vikas

[tresesco]

Have you tried this?:

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

-

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

)/1000

[vikasmahajan]

Hello

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

any idea ?

Vikas

[tresesco]

Can a sample app be posted?

[vikasmahajan]

No  Application can be share.

[MayilVahanan]

Hi

Try like this

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

-

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

)/1000

[vikasmahajan]

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

[CELAMBARASAN]

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.

[tresesco]

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

[vikasmahajan]

Thx a lot for your quick answer.

I tried and unfortunately it doesn't work.