Hi,
How can I use FormulaBuilder to compile only summary level formula?
I am allowing the user to configure a Summary (SummaryType.Formula) based on 1 or more columns. I would like to use FormulaBuilder to allow the user to create the formula.
Thanks
Sangeetha
HI Sangeetha,
I am not sure what you are asking, exactly. It sounds like maybe you want to show the FormulaBuilder dialog to the user so that they can create their own formulas. If that's what you want, there's a sample of this in the WinGrid Samples explorer.
Hi Mike,
Thanks for your reply.
Yes I do display the FormulaBuilder and allow the user to build a formula for the SummarySetting.
My question is, since the formula is to be applied to a SummarySetting, I want the FormulaBuilder to compile the formula as successful only if the Formula is a SummaryFormula.
For example,
For formula [Price]*[Quantity] FormulaBuider should display that there are compilation errors.
For formula Sum[Quantity] FormulaBuilder should display that it Compiled Successfully.
In short, FormulaBuilder should only compile Summary formula successfully and display compilation errors for non-summary formula.
Hi Sangeetha,
There's no way to do this. The FormulaBuilder can evaluate a formula display errors in syntax, but the error you are talking about here would be a reference error and it has no way to evaluate those.
Thank You Mike