Set analysis

[nareshthavidishetty]

Hi ,

I'm getting the expression error while writing the logic.

Error is at Highlighted  arrow.Please find the below.

Logic :

If(District_RetailScorecard = 'Company' or [Sold Location] = '999',

    (sum({1<[Reported Date] =  {"$(='>=7/1/2016<=7/31/2016')"}>}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

      If(/*District_RetailScorecard='District' or*/  [Sold Location] = '888',

        (sum({1<[Reported Date] =  {"$(='>=7/1/2016<=7/31/2016')"}>},'M/D/YYYY'))"}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

       (sum({1<[Reported Date] =  {"$(='>=7/1/2016<=7/31/2016')"}>}, 'M/D/YYYY'))"}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} [Store Quota Amount]) * vMTDQ))

Image:

Thanks..

[sunny_talwar]

See if this helps:

[Sold Location] ={'*'} - {'040', '051', '099', '531', '800', '090','108'}

[Anonymous]

try to Change the sign - before = (minus before equal)

[Sold Location] -= {

[nareshthavidishetty]

Hi Sunny,

Still am getting the error..Please find below,

Thanks..

[sunny_talwar]

My bad, your error is here:

sum({1<[Reported Date] =  {"$(='>=7/1/2016<=7/31/2016')"}>}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

Those need to be removed

sum({1<[Reported Date] =  {"$(='>=7/1/2016<=7/31/2016')"}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

[trdandamudi]

May be as below:

[Sold Location] - = {'040', '051', '099', '531', '800', '090','108'}>}

[sunny_talwar]

I don't think that is an issue. This just says that the result should change based on selection vs what he has won't change based on selections. I think the issue is here

[trdandamudi]

You have a point and it makes sense.... Also having the - (minus sign) after = (Equal) is incorrect or not ?

[sunny_talwar]

I think it is not incorrect to have it there.

[sunny_talwar]

In simple terms, it is correct to have a negative after the equal sign