Using your own formula and displaying its result

Problem:

You want to display the result of your own mathematical formula.

Solution:

You can generate content for a column using your own mathematical formula. For that column, you must use content: generated in addition to type: number and formula: "<desired formula>". And to make sure that the Klip reserves space for this generated content, you must use definition: all with type: item (see the definition for sales in the example below).

Once the formula is specified for a column, a horizontal line is drawn under the last item in the Klip, with the result of the formula displayed under it by default.

For example, let's say we have some data on how many of our products were sold today and yesterday, and we want to see the increase in sales.

sales {
    type: item;
    definition: all;
}
yesterday {
    type: number;
    itemcol: 2;
    formula: sum;
}
today {
    type: number;
    itemcol: 3;
    formula: sum;
}
increase {
    type: number;
    itemcol: 4;
    content: generated;
    formula: "today-yesterday";        
}

The values for each store under the "yesterday" and "today" columns come from a data source, while values under the "increase" column were generated using the formula today-yesterday as shown above. In the results area, the "yesterday" and "today" columns show the sum of all values for each, and the "increase" column's footer displays the result of "today-yesterday" (187-145=42).

If you want to use the formula property but do not want to display the result under the horizontal line, use showresult: false.