Hi all,
Is it possible to use expressions stored in INLINE tables?
I want to make a straight table with fixed rows, an index (for sorting), a name and 3 KPI's with their uom's.
This is the code I use to create the INLINE table:
LOAD
* INLINE "
EO_INDEX, EO_NAME, EO_KPI1, EO_KPI1_UNIT, EO_KP2, EO_KPI2_UNIT, EO_KPI3, EO_KPI3_UNIT
1, Dispatch, =sum(Dispatch), MW, =sum([APX price]), €/MWhe, =sum([E revenue]), €/hour
"; This is what I get in the fields/table.
| EO_INDEX | EO_NAME | EO_KPI1 | EO_KPI1_UNIT | EO_KP2 | EO_KPI2_UNIT | EO_KPI3 | EO_KPI3_UNIT |
| 1 | Dispatch | =sum(Dispatch) | MW | =sum([APX price]) | €/MWhe | =sum([E revenue]) | €/hour |
When I try to use for instance field EO_KPI1 in a chart (straight table) then I only see the text like this:
I tried different expression in the straight tablee, like: =EO_KPI1, EO_KPI1, ONLY(EO_KPI1)
I would like to have the value of sum(Dispatch) displayed.
Is this possible, am I close? I hope someone can help me.
Thanks in advance!
Regards,
Stefan
