Forum Discussion
Edit a calculated column in Query Editor
Good morning,
I created a calculated column in query editor ages ago, and i've realised that for some reason it's stopped working properly so I want to check what it's doing.
I want to view/edit the formula, but I don't know how to do this.
I'm in Query Editor, i've got the column highlighted, how do I edit?
Thanks!
Jemma
hi Jemma
in View ribbon you need the Query Settings pane enabled - it shows list of steps in currently selected query
you need to identify the step which added the column and click on the gear icon next to it - it will bring back the add column window, where you can edit
Hi Anonymous,
Just double left cilck the step in the APPLIED STEPS field, then you can edit the formula.
Regards,
Frank
2 Replies
hi Jemma
in View ribbon you need the Query Settings pane enabled - it shows list of steps in currently selected query
you need to identify the step which added the column and click on the gear icon next to it - it will bring back the add column window, where you can edit
Hi Anonymous,
Just double left cilck the step in the APPLIED STEPS field, then you can edit the formula.
Regards,
Frank