-
To generate beast mode calculated field.
I need to get percent complete in Gantt chart per below request. Filter column `Region_TWC` to get each filtering. ‘NAM’ , ‘EUROPE’ , ‘PACIFIC’ , ‘JAPAN’ , ‘KOREA’ , ‘GCA’ , ‘SEA’. Then filter column `Meet FOB DL_AR`, to get the rows which is equal to 'Meet AR DL' After above filtering, to get each region’s total `Ordered…
-
Get percent complete in Gantt chart
I need to get percent complete in Gantt chart per below request. Filter column `Region_TWC` to get each filtering. ‘NAM’ , ‘EUROPE’ , ‘PACIFIC’ , ‘JAPAN’ , ‘KOREA’ , ‘GCA’ , ‘SEA’. Then filter column `Meet FOB DL_AR`, to get the rows which is equal to 'Meet AR DL' After above filtering, to get each region’s total `Ordered…
-
Sum of all Subtotal of separate item isn't equal to Total number
I made a beast mode 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 PQ) WHEN SUM(CASE WHEN Region_TWC IN…
