Summary
It's possible to disable Yellowfin's validation of calculated fields with a string entry in the configuration database.
You may want to use this hidden feature if you are creating a large number of the same calculated field and the validation takes a prohibitive amount of time.
Disabling Validation
You can turn off the validation of calculated fields when clicking the Save button by running the following query:
INSERT INTO Configuration
VALUES ('1', 'SYSTEM', 'VALIDATECALCONSAVE', 'FALSE')
There are some additional steps to take to make it work:
1) Before you create your calculated field that you don't want validated, save a calc field that has the correct data type for what you intend your final calc field to return. For example, save a calc field whose formula is 1 (i.e. integer).
2) Then edit that calc field you just saved and delete the formula of 1, and enter your intended formula, this will then save without validating. You can easily test this out with a formula like SUM('xxx')
(If you prefer a video demonstration, please see the attached 2 minute demo of the above steps)
If you are have any further questions on this article, contact Support with a new ticket or send us an email.