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.

[sunny_talwar]

It is explained in detail here

Implicit Set Operators

[alis2063]

Thanks buddy