# Dataset columntype formula problem in 1.7
**URL:** https://community.xibo.org.uk/t/dataset-columntype-formula-problem-in-1-7/4501
**Category:** Help Topics
**Created:** [December 18, 2015, 8:00pm UTC](https://community.xibo.org.uk/t/dataset-columntype-formula-problem-in-1-7/4501 "2015-12-18T20:00:29Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Kimia](https://community.xibo.org.uk/u/Kimia)
#### Post date: [December 18, 2015, 8:00pm UTC](https://community.xibo.org.uk/t/dataset-columntype-formula-problem-in-1-7/4501/1 "2015-12-18T20:00:29Z")
I would like to add a column type formula in a dataset that will allow me to perform an operation similar to the following mysql code:
SELECT Sum(Value) FROM `datasetdata` Group by RowNumber
what should I enter in the ‘Formula’ part?
---
### Author:  [@dan](https://community.xibo.org.uk/u/dan)
#### Post date: [December 21, 2015, 1:35pm UTC](https://community.xibo.org.uk/t/dataset-columntype-formula-problem-in-1-7/4501/2 "2015-12-21T13:35:50Z")
Your statement doesn’t really make sense - the `datasetdata` table is a normalised representation of your data, where the value can come from any column (this is changing in 1.8 as it happens, where the table will be materialised).
Beyond that (and unfortunately) I can’t think of a way to aggregate a column in that fashion - other than to write your own module which accesses the dataset directly (some variant on the datasetview module).
If you do look at that you might want to consider developing it against 1.8, which has the materialised view I mentioned.
---
### Author:  [@system](https://community.xibo.org.uk/u/system)
#### Post date: [March 4, 2020, 5:04pm UTC](https://community.xibo.org.uk/t/dataset-columntype-formula-problem-in-1-7/4501/3 "2020-03-04T17:04:30Z")