Elastic Report – formulas

[gabeirinhas]

Hello,

By applying the following formula I get the difference correctly, as well as the total of the difference obtained.

<Column name=”Dif” calcType=”Diff” calcTotal=”true” calcAvg=”true” calcMin=”true” calcMax=”true” />

I have applied a multitude of calcType=”Formula”, so that the calcTotal is only applied to those values obtained that are negative.

I am running out of ideas, is there any way to do this, or is it not possible, I am using rapid scada v5, thanks for your help.

[Mikhail]

Hello,
Formulas that calculate totals are predefined. Unfortunately, you can’t calculate only negative values in the described case.

However, a section of the DataData type can contain a custom formula. May be you can use a custom formula in the DataData section that refers the previous TimeData section.

Note: Elastic Report formulas work only in Excel format.
Note2: Elastic Report 6 supports XLSX format instead of Office XML 2003.

[Author]

Posts