Table visualisation

[delbooth]

Hi.

I have 5 column table visualisation, with the columns :

1 Vehicle Registration - generated from reading a field in atable

2 Availability - generated via calculation using data from fields in tables

3 Performance -generated via calculation using data from fields in tables

4 Quality -generated via calculation using data from fields in tables

5 OEE -generated via calculation using data from fields in tables

My questions are

1. Is it possible to multiply column 2,3 and 4 to get a value in column 5 without combining the calculations used in columns 2,3 and 4 as it becomes very large ie by saying in column 5 measure multiple column,2,3 and 4

Thanks

[PabloTrevisan]

Hi,

use Column(number of the column)..

example:

Column(1) + Column(2) - Column(3)

[kaanerisen]

Hi Del,

Just use column names in expression.

For ex:

([Performance]*[Quality])-[Availability]

It may show error on expression editor but it will work as you want.

[mithilesh17]

Hi,

In your case, write this in Column 5 ->  Column(2) * Column(3) * Column(4)

[delbooth]

Thanks

[PabloTrevisan · Accepted solution]

Please Del, if the answer helped you, please check the correct answer.

thks