sum certain values of a column with conditions in Crystal Reports

AndreT78 1 Reputation point
2022-11-22T14:07:58.047+00:00

Hi,

II have a table with 2 columns.
VAT rate (RATTAXLIN_0) and value (AMTTAXLIN_0)

in the table are values with 7 and 19 percent VAT rate.

I just want to sum up the ones that have 7 percent.

I thought this would be easy, but it doesn't work.
What am I doing wrong, how is it right?

if {SINVOICED.RATTAXLIN_0} = 7 then
sum({SINVOICED.AMTTAXLIN_0})

Thanks for help.

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,869 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2022-11-23T05:25:12.657+00:00

    Hi @AndreT78
    Sorry we only support services related to Microsoft products. If you have Crystal Reports-related questions, then I suggest you go to Crystal Reports-related platforms to ask.
    Best regards,
    Aniya

    0 comments No comments