Hi,
How can i set the formula for an unbound filed at runtime.
I have a grid and i want to display the sum of any two fields in an unbound field by setting formula at runtime. How can i proceed?
Thanks
main requirement is to set the formula string at runtime.
Hello,
You have to add a XamFormulaEditor and set its Target property to the UnboundField. Hope this helps!
Thanks,
Diyan Dimitrov
Thanks for the response.
This surely solves the problem for applying single formula on fields. What i want is to be able to set formula via my code.
Lets take a scenerio :
Say i have 6 fields in a grid
The sum of first two fields is to be displayed in 3rd field while the difference of 4th and 5th to be displayed in 6th field.
I dont want to set the formula inside the .xaml file. How can i set these two formulas in my code file?
Or another scenerio
I have 4 fields in my grid. sum of first to is shown in 3rd field while difference of first two is shown in 4th field.
I am able to obtain this result by setting formula in xaml file. But how can i obtain similar result via my code? ie setting FieldCalculationSettings.Formula = ?
Hello Saurabh,
Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.
Hi
Sorry was late in testing out the example
Thanks Diyan for the example..this shoud get me going
Thanks all for the effort..
I am just checking if you got this worked out or you still require any assistance or clarification on the matter.
You have to set the Field.CalculationSettings.Formula in the code behind. I am attaching a sample project with a grid with 4 fields, 2 of them are UnboundFields which have formulas set in code behind in the Loaded event of the Window. Hope this helps!