Hi Clayton,

When using the Freehand SQL option you have the ability to edit the formula without having to start over.

Regards,
Stephen

It would really be helpful to be able to type into the formula box. The SQL calculated field is a different animal.

Here is an example of why the inability to type into the formula edit is very annoying and laborious.

I spent about 10 minutes building this formula from the various list boxes, popups, and buttons:
CASE WHEN SUM ( Prev Month MRR ) = 0 THEN SUM ( Canceled Account MRR + Downgrade Account MRR - Prev Month MRR ) * 1.0 / SUM ( Prev Month MRR ) ELSE 0 END

And then I discovered that I should have made it "!=0" instead of "=0". So now I have no option but to wipe the whole thing out and start over.

So I took your suggestion and tried to use the freehand sql and typed this in:
CASE
WHEN SUM("MonthlyCustomerStats"."beginmrramount") != 0 THEN SUM("MonthlyCustomerStats"."canceledaccountmrramount" + "MonthlyCustomerStats"."downgrademrramount" - "MonthlyCustomerStats"."beginmrramount") * 1.0 / SUM("MonthlyCustomerStats"."beginmrramount")
ELSE 0
END

But I keep getting the invalid SQL message and have no idea why because the SQL works fine from a SQL tool.

Thanks!

Hi Clayton,

When a query is invalid Yellowfin usually displays the error message that it received from the database driver, for example like below:





and also Yellowfin logs it in the yellowfin.log file like below:
[code]
YF:2014-02-06 14:51:47:ERROR (DBAction:doSelect) - Error occured selecting data: java.sql.SQLException: Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
java.sql.SQLException: Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
[/code]

Are you able to show us either of the above messages?

regards,
Dave

Hi Clayton

YF 7 does allow you to edit portions of the formula



Clicking on the selected portion of the CASE statement will open it up in the Formula builder to edit the selected portion of the formula



This should allow you to make you changes without having to undo the whole formula

Hope this helps you to achieve what you are trying to do.

Regards,
Stephen

Yes, that is an improvement. However there is no way to insert something in the middle, etc. Hopefully a future release will allow full editing of the formula box. Thanks.

I have Yellowfin 7.1 But i can't edit the formula by typing anyway.
Do i have to activate anything before ?

I have Yellowfin 7.1 But i can't edit the formula by typing anyway.
Do i have to activate anything before ?

Hi Guest,

It sounds like you might be misunderstanding how the Formula Builder actually works. You aren't actually allowed
to 'type' into it, instead you have to use the pre-defined prompts and drop downs in order to build your formula.

I have included our latest Wiki link HERE for your review.

I have also included a screencast HERE that provides a quick example of the formula builder in action.

Please let us know if you need additional assistance with this.

Regards,

Kyle

This formula editor is the Most useless and Most unfriendly editor ever. Make more mistake to user , totally annoying.

This formula editor is the Most useless and Most unfriendly editor ever. Make more mistake to user , totally annoying.

I can finish this by typing in 10 sec , but this formula builder make me click and type and click and type and click . What for?

Productivityless feature

who are you? Identify yourself...do not hide behind your cloak of anonymity!

I am the guy who did 2 previous comment.
unfortunately , I don't know how to Sign Up this website.
I came from Thailand and that are all my opinion of that feature.

I always though this is public forum to help each other fix the problem and recommend everything you want ,told the bug you found to help this tools improve.

However if you want me to identify myself, your should identify yourself first before beg me,do not hide behind your cloak of anonymity!

Hi People,

Thank you all for your feedback and suggestions on our product.
While we appreciate all feedback, we do not condone any comments which may be seen as inappropriate or negative towards a person.

The calculated field builder does have a number of features to give you the results you were after, and similar functions can also be replicated using other features of the product such as ; freehand view builder, freehand calc builder,freehand report builder, or even virtual tables .

We do not have any current plants to support freehand text within the calculated field formula builder.

Sorry for the bad news, and hope we can all just get along :)

Regards,
David