Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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?
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])
I'm still getting an error in the expression.
Hi,
It doesn't matter, when you are using variables, the expression checker is not working properly, try if works.
Try this?
= Count({< ROIC = {"$(= $(ROIC) >= 1)"} >} DISTINCT [Part_Number])
I would think something like this
=Count({< Part_Number = {"=$(ROIC) >= 1"} >} DISTINCT [Part_Number])