Issue using enrichment map columns in Cytoscape formula builder

[risserlin]

Issue received through email from Laura Lewandowski -

I am running into an issue in trying to use a formula in an added column in enrichment Map. I am trying to take the -log of the pvalue, but when I enter log (enrichment map::pvalue) I get the following error: The training videos or github documentation do not address this.

Verified issue was EM columns. Created a fake column with fake p-values called my_pval and was able to create a formula using that column and -log function.

Maybe is there a way to escape the EM column name to get it to work?

[risserlin]

Work around - you can rename the EM column name and even though it gives you an error it renames the column and will work with functions after that.

Error when you rename the column -

[Lauralew11]

Hello! I am the person who submitted this bug report. This work around works beautifully- thank you so much for the help!

[mikekucera]

The problem is the parenthesis in the column name. You will have to escape them in the formula editor using backslashes, like this... ${EnrichmentMap::pvalue \(8_1_22_KH_metascape\)}

I will open a bug on Cytoscape for this, either the parenthesis should be accepted as they are, or the formula builder should automatically insert the backslashes when inserting the column name.