Forum Discussion
Split the result
Hi, Is it possible that I can split the result for the result of "G" and "M" in the Serology test? this is my table and my data Any guidance to solve this? ...
Anonymous Try something like this:
result measure=
IF([Type]="Serology",
IF([detail]="G",LEFT([result],SEARCH(",".[result])-1),RIGHT([result],LEN([result])-SEARCH(",".[result]))
), [result]
)
Anonymous Try something like this:
result measure=
IF([Type]="Serology",
IF([detail]="G",LEFT([result],SEARCH(",".[result])-1),RIGHT([result],LEN([result])-SEARCH(",".[result]))
), [result]
)
Great, Thanks Anonymous .
The results are in accordance with what I expected, like this:
It's just that takes a long time to process if the data is big. Another alternative, I split column result in table screening result into 2 columns, to find "G" and "M" value first, after that create a measure.