Solved

How can I add another field and another specific member in ssrs expression ?

Posted on 2014-12-24
1
108 Views
Last Modified: 2016-02-18
Current:
This formula expression is working as needed.
=sum(IIf(Fields!CAT_ACTUAL_BUDGET.Value="Actual",Fields!SIGNEDDATA.Value,0))

Desired:
Add Fields!DS.Value "TOTW"  
as a filter on the cell where the current formula runs
=sum(IIf(Fields!CAT_ACTUAL_BUDGET.Value="Actual",Fields!SIGNEDDATA.Value,0))

If I can provide additional clarity please ask.
0
Comment
Question by:rhservan
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40518935
Add (including a space before the word " and")

And Fields!DS.Value = "TOTW" 

Open in new window



After "Actual" and before the comma.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now