Member Avatar for mindserve
mindserve 0 Newbie Poster

I have the following on an RDLC report:
=Sum(Cdec(Fields!ServiceCost.Value) - (Cdec(Fields!ServiceCost.value and Fields!Confirmed.value = False)))

The problem is that it takes the false and add's any .00 to the total.
So if it's supposed to be 241.00 and a false evaluates with $31.25 I end up with something like 241.25 not 241.00

How do I format it correctly so that the servicecost which is currency shows the totals ie sum of those that evaluate to false.

below gives me the exact sum total of all false and true combined. But I want to only show where Confirmed.value=false or where it evaluates to true.
=Sum(Cdec(Fields!ServiceCost.Value)

  • 1 Contributor
  • 0 Replies
  • 51 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.