Getting Stuck with IF Condition

[Anonymous]

Hello everyone,

I need your help, I have three region INDIA,NA,US. i want to show INDIA & NA data in hundred(two or three digits) and US data in thousands(45000)   for that i am trying below expression but its not working.

=IF(Region='US',Sum(Value),Sum(Value)/1000)

please help me ..

Thanks.

[tresesco]

Could you please explain the context? Are you trying this in a chart or in textbox or the script?

[Anonymous]

In chart

[tresesco]

Could you share a sample?

[Anonymous]

sorry, i can't share.

[tresesco]

Can you share a screenshot of the chart and the expression you are using (that is not working)?

[sunny_talwar · Accepted solution]

If Region is not one of your dimension, then may be try this

Sum({<Region *= {'US'}>}Value) + Sum({<Region -= {'US'}>}Value)/1000

[Anonymous]

Thanks sunny , its working but the issues is it change the whole US value.

[Anonymous]

Thanks Sunny its working now..

[alis2063]

Hi Sunny,

Why did  you use "*"  before Region?

Could you please explain ?