Variable in Set Analysis

[julesjohnson]

Hi,

Can anyone tell me how to fix this expression.

=Count( {$<$(ROIC)= '{">=1} >} Distinct [Part_Number])

I would like to count the number of parts where the variable ROIC" is greater than 1, for example.

Thanks,

[julesjohnson]

Hi Jason,

Just wanted to let you now that I was never able to make this work.  Thanks again for your help.  I will keep working on it.

Thanks,

Juliette

[vishsaggi]

Can you share a sample app where you have the issue? Where you want to display this data in a text object?

What value can you see for your ROIC variable when used in a text object?

[jmvilaplanap]

Do you have a quote in your expression

Try to take it off and add another one after the 1

=Count( {$<$(ROIC)= {">=1"} >} Distinct [Part_Number])

[julesjohnson]

I'm still getting an error in the expression.

[jmvilaplanap]

Hi,

It doesn't matter, when you are using variables, the expression checker is not working properly, try if works.

[vishsaggi]

Try this?

= Count({< ROIC = {"$(= $(ROIC) >= 1)"} >} DISTINCT [Part_Number])

[sunny_talwar]

I would think something like this

=Count({< Part_Number = {"=$(ROIC) >= 1"} >} DISTINCT [Part_Number])