Column calculation

Sum

Basic usage

<script lang="ts">
    import type { Datahandler } from '@vincjo/datatables'
    export let handler: DataHandler

    const sum = handler.createCalculation('columnName').sum()
</script>

<h1>Total: {$sum}</h1>

Avanced

<script lang="ts">
    import type { Datahandler } from '@vincjo/datatables'
    export let handler: DataHandler

    // calc area from 'width' and 'length' properties
    const calc = handler.createCalculation((row) => row.width * row['length'])

    // set the number of decimal (default = 2)
    calc.setPrecision(3)

    // conversion to yd²
    const sum = calc.sum((values) => values.map((value: number) => value *  1.196))
</script>

<h1>Total area: {$sum} yd²</h1>