Explore Courses Blog Tutorials Interview Questions
+1 vote
in Salesforce by (11.9k points)

I'm trying to query all Opportunities that have a Price that's not a whole number (no decimals) or if its price is not multiple of 10.

Im trying to find prices like: U$S 34,801.23 - U$S 56,103.69 - U$S 50,000.12 etc But not : U$S 49,500.00 - U$S 19,110.00 etc

There are a lot of opportunities in the database, and i can go through them by code but wanted to know if any of you can think of a way to achieve at leaast a part of this by query.

1 Answer

+1 vote
by (32.1k points)
edited by

I actually had the same issue. It seemed like there is a currency setting that is causing this issue.

Want to learn Salesforce from basics! Here's the right video for you on Salesforce provided by Intellipaat:

You can check this at Administrative Setup> Company profile> Manage Currencies.

This will solve your issue.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Dec 14, 2020 in Salesforce by dante07 (13.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories