How many String Formula I can use when create a calculation field
9 January, 2014
Dear Yellowfin Support Team,
I am using Yellowfin 6.1, I found Yellowfin supports the calculation for the metrics field in the Calculation Field Design.
Meanwhile, I would like to have a picture of how may string formulas are supported in Calculation Field Editing.
Would you help to share me some?
Thanks and Regards,
Andy
I am using Yellowfin 6.1, I found Yellowfin supports the calculation for the metrics field in the Calculation Field Design.
Meanwhile, I would like to have a picture of how may string formulas are supported in Calculation Field Editing.
Would you help to share me some?
Thanks and Regards,
Andy
Hi Andy,
I don't have a comprehensive list on me, suffice to say that if the database allows you natively then Yellowfin will too, for example, SQL Server allows you to use the overloaded '+' operator string concatentation and if you try this in the Formula Builder then it will work too.
Any string operations that can't be found in the Formula Builder (e.g. LEFT(), RIGHT()) can be created by either using a Freehand SQL Calculated Field, or Custom Function.
Please let us know if you have any difficulties creating a Freehand SQL Calculated Field, or Custom Function.
regards,
Dave
I don't have a comprehensive list on me, suffice to say that if the database allows you natively then Yellowfin will too, for example, SQL Server allows you to use the overloaded '+' operator string concatentation and if you try this in the Formula Builder then it will work too.
Any string operations that can't be found in the Formula Builder (e.g. LEFT(), RIGHT()) can be created by either using a Freehand SQL Calculated Field, or Custom Function.
Please let us know if you have any difficulties creating a Freehand SQL Calculated Field, or Custom Function.
regards,
Dave
Hi David,
Thanks for your reply. The issue has been resolved.
But I am still interested in Freehand SQL.
Would you share me more documents about Freehand SQL? Just as Grammar, Examples?
Thanks and Regards,
Andy
Thanks for your reply. The issue has been resolved.
But I am still interested in Freehand SQL.
Would you share me more documents about Freehand SQL? Just as Grammar, Examples?
Thanks and Regards,
Andy
Hi Andy,
this is the wiki page on Freehand SQL Calculated Fields in Views.
And here's an example, if I want to use MS SQL Server's LEFT() function to extract the 3 characters from the left of a string then all I've got to do is to get the part of the SQL query that is usually between the SELECT and the FROM words and add it to the Formula tab:
and here's the output:
I hope that helps, please let us know if there are any more questions.
regards,
Dave
this is the wiki page on Freehand SQL Calculated Fields in Views.
And here's an example, if I want to use MS SQL Server's LEFT() function to extract the 3 characters from the left of a string then all I've got to do is to get the part of the SQL query that is usually between the SELECT and the FROM words and add it to the Formula tab:
and here's the output:
I hope that helps, please let us know if there are any more questions.
regards,
Dave