Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I created a straight table in that i have few coulumns,want to disaply a coluimn based on another column two values
I have done getfieldselections(COUNTRY)=INDIA ,Its working but i want to give one more value
like getfieldselections(COUNTRY)=INDIA and getfieldselections(COUNTRY)=US
its not working for me it is working for only one value.
Please suggest for this
try with this =If(Match(GetFieldSelections(COUNTRY),'INDIA','US','JAPAN'), COUNTRY)
Vikas
try
if(match(Country,'India','US'),1,0)
or
if( Country ='India' and Country='US',1,0)
Not sure if this is truly and requirement where you would make multiple selections in the COUNTRY filter or if this is just an or requirement.
If its INDIA and US, try like this:
SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'INDIA') = 1 and SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'US') = 1
If its INDIA or US
SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'INDIA') = 1 or SubStringCount(Concat(DISTINCT COUNTRY, '|'), 'US') = 1
If it is your calculated dimension then try like this?
=IF(Country='INDIA' or Country='USA', Country)
If it is your expression then try like this?
=sum({<Country={'INDIA','USA'}>} Sales)
Hi Kush,
Its working for India or US and
i need third scenario like INDIA and US.
Means 1.India
2.US
3.INDIA and US
for third scenario waht i need to do?
Please do the needful
HI Sunny
Its working for India or US and
i need third scenario like INDIA and US.
Means 1.India
2.US
3.INDIA and US
for third scenario waht i need to do?
Please do the needful
Its working for India or US and
i need third scenario like INDIA and US.
Means 1.India
2.US
3.INDIA and US
for third scenario waht i need to do?
Please do the needful
Which of the two expression worked?
if(match(Country,'India','US'),1,0)