6 Replies Latest reply: Feb 2, 2011 4:17 PM by RickInNC

# Set Analysis Question

I have the following in a text box:

`=Only([Fiscal Quarter])`

This displays:

Second Quarter

In a chart I have:

`Sum( {1//< [Fiscal Year] = {\$(=Only([Fiscal Year]))}, [Fiscal Quarter] = {'Second Quarter'} ><[Fiscal Year] = {\$(=Only([Fiscal Year]))}, [Fiscal Quarter] = {\$(=Only([Fiscal Quarter]))}>}Pounds )`

If I comment the attempt to use the value selected and use the literal I get results, if I try to use the selected quarter, I get no results.

Rick

• ###### Set Analysis Question

It looks fine to me on the surface. One cool trick is to not name (label) the expression. When displayed, it will show what each part of the expression evaluates to. You might have to spread the column to see the entire expression.

• ###### Set Analysis Question

In the label =(Only([Fiscal Period]) displays "Second Quarter" (without quotes)

• ###### Set Analysis Question

In the label =(Only([Fiscal Quarter]) displays "Second Quarter" (without quotes)

• ###### Set Analysis Question

Here's what you should be looking at:

`[Fiscal Quarter] = {'Second Quarter'}`

There are your quotes. String values in element sets require quotes. Numeric values do not, which is why your Year field is acceptable.

• ###### Set Analysis Question

There is a difference between your literally defined value and the value returned by the dollar sign expansion, quotes.

Your expression didn't paste well, but here's the important part:

`...[Fiscal Quarter]={'\$(=Only([Fiscal Quarter]))'}>...`

• ###### Set Analysis Question

Thank you, that did it.. those pesky quotes I forgot.