Problem with Set Analysis

[bimala0507]

Hi Experts:

Can anyone say me, what is wrong with Below expression

if(id1=1,num(sum({$<Year_F_SHIP_DATE={$(=max(Factory_Assesment_Year))}>}[Qty (Pcs)]), '#,##0'),if (id1=0,num(sum({$<Year_B_SHIP_DATE={$(=max(Factory_Assesment_Year))}>}[Qty (Pcs)]), '#,##0')))

Here Factory_Assesment_Year is the Year, what user Select

And Year_F_SHIP_DATE is what the Year, I would like to compare with

Appreciate your immediate attention

Kind Regards,

Bimala

[danieloberbilli]

Why do you consider it as wrong? What result do you get and what result are you aiming for? Do you use it in the script, as a dynamic dimension or as a expression?

[PrashantSangle]

Hi,

Try with "" double quote

try below

if(id1=1,num(sum({$<Year_F_SHIP_DATE={"$(=max(Factory_Assesment_Year))"}>}[Qty (Pcs)]), '#,##0'),

if (id1=0,num(sum({$<Year_B_SHIP_DATE={"$(=max(Factory_Assesment_Year))"}>}[Qty (Pcs)]), '#,##0')))

Regards,

[#4]

Your expression should contain single quote '

as follows:

{'$(=max(Factory_Assesment_Year))'}

and you have

{$(=max(Factory_Assesment_Year))}

Question : Why you use Max ?, is it because a user can select more than one Year  and you are trying to select just the top value of the possible selection?.

Regards,

[ToniKautto]

The answer to your question will depend on what your data looks like, and what you are trying to do. A correct syntax does not guarantee the calculated result is as expected.

Please provide a sample application with data and details on what results you expect.