ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: j.jose on August 30, 2021, 06:48:44 pm

Title: Dynamic Column with Formula Definition
Post by: j.jose on August 30, 2021, 06:48:44 pm

Hallo,

Please advice if its possible to add a formula definition for a dynamic column. I had a look at the example here: https://paramquery.com/pro/demos/ko_columns

Its possible to add new columns, but how can we define whats to be displayed as values.

For example, I have the data for two years in two columns and in a dynamic column, I would like to see the sum of the two years values.

Could you please guide me to an example of this sort.

Thanking you in advance!

Best regards,
Jiny

Title: Re: Dynamic Column with Formula Definition
Post by: paramvir on September 01, 2021, 10:23:20 am

New columns can be added dynamically with convenient grid.Columns().add() API

formulas can be defined for static as well as dynamic columns with formulas option.

Example of formula: https://paramquery.com/pro/demos/grid_formula