Lester_Tai Member

Comments

  • Hi, Let me explain it more clear. Below is the example: I have a PO list in the table and would like to get each region's data per my beast mode. Per my request, if "Ordered unit" is equal or more than "PAR in PQ" and "Meet AR DL", return "PAR in PQ" else return "Ordered unit". When I run the best mode, it will be correct…
    in To generate beast mode calculated field. Comment by Lester_Tai April 24
  • David, sorry for confusion. Let me explain it more clear. Below is the example: I have a PO list in the table and would like to get each region's data per my beast mode. Per my request, if "Ordered unit" is equal or more than "PAR in PQ" and "Meet AR DL", return "PAR in PQ" else return "Ordered unit". When I run the best…
    in Get percent complete in Gantt chart Comment by Lester_Tai April 24
  • Sorry, i it doesn't work. I changed the beast mode to as below. CASE WHEN SUM(CASE WHEN `Region_TWC` IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND `PO Type` IN ('Sample','Demo','SF','M0','M1') AND `Meet FOB DL_AR`= 'Meet AR DL' THEN `Ordered unit` END) >= SUM(DISTINCT `PAR in PQ`) THEN SUM(DISTINCT `PAR in…
    in To generate beast mode calculated field. Comment by Lester_Tai April 19
Default Avatar