Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please Del, if the answer helped you, please check the correct answer.
thks
Hi,
use Column(number of the column)..
example:
Column(1) + Column(2) - Column(3)
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.
Hi,
In your case, write this in Column 5 -> Column(2) * Column(3) * Column(4)
Thanks
Please Del, if the answer helped you, please check the correct answer.
thks