[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

Crystal Reports

Hi,

 How to change decimal places dynamically in Crystal reports depends up on currency code
0
CMANI10
Asked:
CMANI10
1 Solution
 
peter57rCommented:
Do you mean you want to display different numbers of decimal places depending on the value of another field holding the currency code?

If so then you can use the conditional format button on the Number custom tab in Format Field.  (Right click the field , choose format field, then choose the Number tab and then click Customize)

You use an expression like..

If {Table.Currencycode} = "xxx" then 4
else if {Table.Currencycode} = "yyy" then 0
else 2
0
 
mlmccCommented:
You may also want to round to that number of decimal places.  You can change the rounding with a similar formula

mlmcc
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now