how to get total sum

[Ashutosh11]

sum(comsumed_qty)
/
SUM(total(count({<JS_Closed_Flag_TAT1={'T'},repair_c-={'Pending For Part'},type_c-={'Reschedule'},
repair_c-={'Pending for Part'},complain_type={'Productive'},product_type-={'3'}>}distinct job_sheet)))

let me know how to get total  % for this expression. This expression showing blank value.

[Chanty4u]

try this

IF(SUM(total count({<JS_Closed_Flag_TAT1={'T'}, repair_c-={'Pending For Part'}, type_c-={'Reschedule'},
repair_c-={'Pending for Part'}, complain_type={'Productive'}, product_type-={'3'}>} distinct job_sheet)) = 0,
NULL(),
(SUM(comsumed_qty) / SUM(total count({<JS_Closed_Flag_TAT1={'T'}, repair_c-={'Pending For Part'}, type_c-={'Reschedule'},
repair_c-={'Pending for Part'}, complain_type={'Productive'}, product_type-={'3'}>} distinct job_sheet))) * 100
)