-
Re: Transform selections in the field by a common rule
Глеб Аитов Jun 9, 2017 6:17 AM (in response to Глеб Аитов)the answer to Question 2 is below
-
Re: Transform selections in the field by a common rule
Sunny Talwar Jun 9, 2017 6:21 AM (in response to Глеб Аитов)How is vPY defined?
-
Re: Transform selections in the field by a common rule
Глеб Аитов Jun 13, 2017 3:39 AM (in response to Sunny Talwar )if (Upper("Season")=Upper('allseason'),'allseason',
if (SubstringCount(Upper("Season"), 'SS')>0, '[Season]={'&chr(39)&(Left("Season",2)-1)&' ss'&chr(39)&'}',
if (SubstringCount(Upper("Season"), 'FW')>0, '[Season]={'&chr(39)&(Left("Season",2)-1)&'-'&(Mid("Season",4,2)-1)&' fw'&chr(39)&'}',
'[Season]='
)))
-
Re: Transform selections in the field by a common rule
Sunny Talwar Jun 13, 2017 3:43 AM (in response to Глеб Аитов)What is seasons here? Would you be able to share a sample to look at?
-
Re: Transform selections in the field by a common rule
Глеб Аитов Jun 13, 2017 4:37 AM (in response to Sunny Talwar )season is the collection of apparel sold in particular year.
The values are as follows:
ss 15, ss 16, ss 17 and etc.
fw 15-16, fw 16-17, fw 17-18 and etc.
The formula works as follows:
when i choose ss 16, the variable returns Season={'ss 15'}, when i choose fw 16-17, the variable returns Season={'fw 16-17'}
When more than one season values are selected ss 16 and fw 16-17, the variable returns nothing.
I want it to return Season={'ss 15, fw 15-16'}
It might be a solution which just came to my mind:
1. what if i create a second field name SeasonCompare
2. In the script I predefine a "pair" for each season, by putting a formula from vPY, it will create the following table:
Season SeasonComp ss 16 ss 15 fw 16-17 fw 15-16
3. Than in the set analysis: SUM ( {< Season=SeasonComp>} Sales ). So when I choose multiple values in the field Season, like ss 16 AND fw 16-17, it will show the sales for values from the SeasonCompare field. Does that make sense?
it's quite hard to share the sample, sorry. It is a part of a large data set.
-
-
-