Basic IF statement

[khaycock]

Hi,

I'm not sure on the best way to do this, whether it be a calculation condition or not..

I have a table box that I only want to be displayed when 'ResponseFlag = No'

I thought it would just be a basic IF statement like this: IF(ResponseFlag = 'No', 1,0) but doesn't work.

Any ideas?

[Anonymous]

goto layout and there show conditional and just define

ResponseFlag = 'No'

[swuehl]

If you are using this in a calculation condition, it will be evaluated in global context, i.e. it will only return an unambiguous result if all records show the same value for ResponseFlag.

In general, you need to consider using aggregation functions, though I am not sure how this should look like in your case:

Use Aggregation Functions!

[Anonymous]

Go in

Properties > Layout. Activate the conditional option and then put your statement there.

[khaycock]

I want the table to show regardless but just want fields to be displayed in it that have ResponseFlag ='No'.

When I put that into layout conditional it gets rid of the whole table?

[swuehl · Accepted solution]

The Show or Calculation condition will affect the complete chart, it is not evaluated per row.

You can use a straight table or pivot table chart with calculated dimensions or set analysis to filter the rows.

For example, try to create a straight table chart with all fields from the table box used as dimensions, then a single expression

=Count({<ResponseFlag = {No}>} ResponseFlag)

You can hide the expression column on presentation tab if you want.