Hi Qlik learners,
I have one scenario
I want to calculate the average of field dived by another field
Ex : D_CST_QUOTE_WI_DURATION_BD dived by NUM_PRODUCTS by month wise dimension is REPORTING_DATE
Condition is :
If(Upper(WORKITEM_NAME)='CSTQUOTEWI'
and Upper(WORKITEM_STATUS)='CLOSED',
(D_CST_QUOTE_WI_DURATION_BD/NUM_PRODUCTS)) as ALTER_CST_LEAD_TIME
this is the script i have written in backend
When I have added this field ( ALTER_CST_LEAD_TIME) i want show average by monthwise in bar chart but average is not matching with Excel average and Qlik Average please help me
