Error using Set Analysis with Variable

[#1]

Hello everyone,

I need your help,

I have some troubles with an expression using set analysis and a variable too.

This is my exprssion in a pivot table :

sum({$ <{$(vAndSubFamily)$(vNotSubFamily)}, Type = 'Actuals' >} [Amount])

$(vAndSubFamily)$(vNotSubFamily) are two succesive products choices

Actuals is a filter on the Sales Type , I have other Types like Budget and Quotations.

Do you know where the error comes from ?

Thank you,

Have a nice day,

David

[ashfaq_haseeb]

Its ok its learning curve

Your variable gives error

=if(count({NOT} distinct SubFamily)<>count({NOT<SubFamily>} distinct SubFamily), //some products selected (but not all) '*' & concat({$*NOT} distinct '<' & vRelevantField & '=E({<SubFamily={' & chr(39) & SubFamily & chr(39) & '}>} ' & vRelevantField & ')>','*',SubFamily), ' <$Field>')

Its not returning value.

Regards

ASHFAQ

[#3]

I try to search more in order to resolve it.

I just don't understand why everything working with :

sum({$(vAndSubFamily)$(vNotSubFamily)}Amount)

and not with

=sum({$ <SubFamily={'$(vAndSubFamily)','$(vNotSubFamily)'}, Type = {'Actuals'}>} [Amount])

Regards

David

[ashfaq_haseeb · Accepted solution]

Contact me

myskypeID:ashfaqhaseeb

Regards

ASHFAQ

[#5]

Ok,

I will contact you.

Thanks,

Regards,

David

[#6]

ASHFAQ,

Thank you so much for your help. You made my day !

If it interest somebody the solution was :

=sum({$(vAndSubFamily)$(vNotSubFamily)*<Type={'Actuals'}>} [Amount])

David

[ashfaq_haseeb]

Welcome

Regards

ASHFAQ