Condition not working

[Vince_CH]

Dear,  I want to make some purchase KIP like below indication. it worked well in YTD and LYTD in the fiscal year calendar. as the purchase value originally in different currency, i try to add the condition of PUR_Currency={'RMB'} as in the expression, however, it doesn't work with adding this. can someone help to verify why?? thank you

[Anil_Babu_Samineni]

Are you getting without that? If yes, Then Restricted value should Case sensitive. Check you provided same as Data source?

[shiveshsingh]

Are you getting any result after adding this PUR_Currency condition?

What are the distinct values for PUR_Currency?

[Vince_CH]

Gents, thanks for reply.

without the adding PUR_Currency={'RMB'}, it is working well, it failed with adding.

the distinct value of PUR_Currency are as following.

[shiveshsingh]

PUR_Price * PUR_Currency1

Is this expression having any value for the condition that you have used?

[Vince_CH]

Dear Shiveshsingh, yes, PUR_Currency1 is some factor related with currency, price is value, it worked well in case without adding PUR_Currency={'RMB'}. it might be sensitive because of too many conditions inside? or any other alternative way can achieve some target?

[Anil_Babu_Samineni]

Is there a way, That i can expect sample file?

[shiveshsingh]

Hi

Need to check your data.. can you share sample?

[Vince_CH]

Try to make some data, will send after a while

[Vince_CH]

Dear , as i tried to send the qvf file in 782kb, it failed and indicated " the contents of the attachment doesn't match its file type", what is the problem? file too big?