Author Topic: Dynamic Column with Formula Definition  (Read 1596 times)

j.jose

  • Newbie
  • *
  • Posts: 8
    • View Profile
Dynamic Column with Formula Definition
« 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6210
    • View Profile
Re: Dynamic Column with Formula Definition
« Reply #1 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