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,
Is the variable ROIC a single value or a list? Please hlep me understand what you're trying to do.
Hi Jason,
It is a calculated value derived from Profit/ Investment.
Ok, so it's a static value? Is it always > 0?
Hi Jason,
It is calculated so no, not static. Yes, there is a possibility that it can be negative.
Thank you. Do you have a field associated with the variable (ROIC)? It looks like you're using set analysis to create a data set using ROIC, but I don't see a field that can be >=1 in your expression. In other words, the variable can be >=1, but the variable isn't linked to a field the correlates to the Part Number. If you have the field, I might be able to help with the expression.
Hi Jason,
I am not sure I get what you are asking.
What I am attempting to do is say count the number of parts where the calculation for ROIC > 1.
In the following example, the number returned should be 2.
Part # | Description | ROIC |
z45 | Crank | -2 |
x25 | Lever | 5 |
f85 | cover | 0 |
h85 | line | 1.2 |
Ok, that makes more sense. ROIC isn't a variable, it's a field.
Try this: count({<ROIC={'>=1'}>} Distinct Part_Number)
Of course, the result will depend on what dimension you use. Using your example, I would use Description.
Thanks for the suggestion but unfortunately that did not work. ROIC is a variable so the $ expansion will need to be added. It is also a field in a table, but I would like to create buckets for a graph where the fields in the table will not be used.
Sorry about that. Will this work: count({<ROIC={">=$(ROIC)"}>} Distinct Part_Number)