Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need to verify if each line in my pick match is zero it is zero I need to put N/A, else the value. There is another way to getting the return of pick match and set the N/A to zero values? or is better do this for each line, with if statement inside pick match?
First of all, thank you for your answer..
I'm doing this
Pick(Match(...),
if (Expression for Match=1 is zero, 'N/A',
Expression for Match=1),
if(Expression for Match=2 is zero, 'N/A', Expression for Match=2
...)
I dont know if +1 is solve my problem
Have you tried? it works
Ok, now I understand, but i don't know otyher way to do that.
Maybe using RangeMax(0, [Expression]) and check the option to supress zero value can work if your table only has one measure.
There is also the alt() function to control no-numeric results but I think it can't work in this case.
I think if you supply the full expression you have, then that will eliminate some guesswork on the part of those trying to help you. Better still, put together and upload a small qvw file with some representative data (does not need to be real numbers, but the structure should be the same), including the sheet object where you need the expression and details on what output values you want.
OK, I'm sorry
I attached one example.