Share via

Visual Studio Expressions

Pam 1 Reputation point
2021-01-27T01:47:24.593+00:00

How do i get this formula to generate a two digit number?

=(Fields!Measurement.Value/fields!TrimmedItems.Value)

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,556 Reputation points
    2021-01-27T05:36:15.813+00:00

    Hi @Pam ,

    Please try like this:

    =FormatNumber(Fields!Measurement.Value/fields!TrimmedItems.Value,0)

    If you mean that you want to format two decimal places, just modify it as

    =FormatNumber(Fields!Measurement.Value/fields!TrimmedItems.Value,2)

    If I misunderstand your meaning, please incorrect me.

    Regards，
    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November