How to get total value In the table, put a bar graph.

[Paknanarn23]

I want to put the Total %Scrap value on the graph.

The conditions will be WorkCenter = MIC,TCC,TCL,TCE,DES.

This is the code used to calculate %Scrap.

What should I do? please help me

[tabletuner]

Do I understand clearly that you want the whole column %Scrap to be filled with the value 7.02% ?

[Paknanarn23]

Yes, you understood correctly, I want to 7.02% shown in the graph

[tabletuner]

Note the addition of the TOTAL statement. 

=Sum(TOTAL {<Plant, etc>}/
if(GetFieldSelections(WorkCore)='INNER',
Sum(TOTAL {<WorkCore_SSD='INNER'},etc
Sum(TOTAL {<WorkCore_SSD='OUTER'},etc

Would this solve the problem?

[tabletuner]

Hi, did my answer help you? Please mark as solved then 🙂