Displaying Associated values of a field in Text Box

[Anonymous]

Hello All,

I am having a field Country with some values and on selection of month from master calender, I want to display associated value of Country in text box?

Any function??

Regards,

Balraj Ahlawat

[Kushal_Chawda]

try this

=if(GetselectedCount(Month) > 0,

if(WildMatch(Concat(DISTINCT Country,','),'*India*'), only({<Country={'India'}>}Currency_Rate),

if(WildMatch(Concat(DISTINCT Country,','),'*US*'), only({<Country={'US'}>}Currency_Rate))))

[Kushal_Chawda]

I am still not clear. Can you please show the output you needed with Sample data?

[Anonymous]

What about else part?

If I have not selected any month then I want same for max of month....

[HirisH_V7]

Hi balraj,

Please post a sample post or give some more info of your requirment.

thanks,

hirish

[MayilVahanan]

Hi

if(GetselectedCount(Month) > 0,

if(SubStringCount(Concat(DISTINCT Country,','),'India')=1, only({<Country={'India'}>}Currency_Rate),

only({<Country={'India'}, Date = {">=$(=MonthStart(Max(Date)))<=$(=MonthEnd(Max(Date)))"}>}Currency_Rate))))

[sasikanth]

HI,

Try some thing like below

=only({<Country={'$(=MaxString(Country))'}>}Rate )

this will work if you didnt select any country.