Forum Discussion

RikMertens's avatar
RikMertens
Frequent Visitor
5 years ago

Using %GT columns in Measures

  Hi all,   I'm trying to create a measure which performs :   Estimated OEE  x  % Time   %Time is de %GT representation of the 'Estimated time'column using the 'show value as' function ...
amitchandak's avatar
amitchandak
Super User
5 years ago

RikMertens , A measure like

[Estimated OEE]*divide([Estimated time], calculate([Estimated time],allselcted(Table)))

RikMertens's avatar
RikMertens
Frequent Visitor
5 years ago

Hi amitchandak  i've got the measure working, thanks! However, the total row now applies the same measure, i would like to see the SUM of the calculated column 'Weighted OEE' here.