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..

[jyothish8807]

Hi Naresh,

I found two issues, which i have highlighted in red:

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

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

Regards

KC

[Anil_Babu_Samineni]

Try This

Logic :

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

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

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

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

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

[nareshthavidishetty]

Hi,

Still Getting the error..

I have simply test below logic in text object and it gives 'Error in set modifier expression'

Logic:=sum({1<[Reported Date]={"$(='>=7/1/2016'<='7/31/2016')"}TOTAL [Store Quota Amount]))

Thanks..

[Anil_Babu_Samineni]

Is there any chance to share the Application. Because, It seems typo error. We will figure out if we get your application

[sunny_talwar]

Where did you Sold Location set modifier go?

Try one of these:

=sum({1<[Reported Date]={"$(='>=7/1/2016'<='7/31/2016')"}>} TOTAL [Store Quota Amount]))

or

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