Transform static data using formula [formula on a column]
-
is it possible to have a column which is set with a default value (as a result of a join) AND a formula. The forumla is an if...then..else which either leaves the value at the "default" or changes it based on the if..then else??? Or, do I need a sep col with the formula to do that?
-
2 Comments
-
I understand what you're saying. You want to use a formula to transform a value. Currently you have to add a new formula field, then delete the previous field, and if using DataManager, this will take two Field Organiser blocks, and renaming the field back will require a 3rd.
It's a good idea - some kind of "Transform with formula" option which allows you to use simple non-data-related functions such as IF and a single "value" reference to create a value transformation. This would apply to a static field and would result in a static field.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.