Trying to indicate <= numeric variable in Set Analysis

[almalecha]

Hello,

I've created a variable vTopBoxScore, and intentionally left the '=' out so it will calculate per row in my pivot table.

NUM((SUM([TB MO Number Indicator NBR]) / Count([TB MO Case ID])) * 100, '##.#'))

In an expression within the pivot table then, I would then like to show a max benchmarking score that is less than or equal to the variable.  I've tried the sytnax below, but it isn't returning anything.  

=MAX({$<[TB Overall BR Benchmark Score Amount] = {"<=$(vTopBoxScore)"}>} [TB Overall BR Benchmark Score Amount])

I've also tried changing the dollar sign expansion to the below, but then it seems to always return the max benchmarking score, and ignore the set analysis all together.

=MAX({$<[TB Overall BR Benchmark Score Amount] = {"<=$($vTopBoxScore)"}>} [TB Overall BR Benchmark Score Amount])

Is there perhaps a different way I should be using the dollar sign expansion, or a different syntax in the expression?   Any help would be greatly appreciated.

Thank you,

Amy

[m_woolf · Accepted solution]

You vTopBoxScore variable has mismatched parentheses

[almalecha]

Ah, sorry, I missed a parentheses when I copied and pasted into my post.

The variable looks like this:

(NUM((SUM([TB MO Number Indicator NBR]) / Count([TB MO Case ID])) * 100, '##.#'))