Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Though its Friday, but still I am here to bug and buzz.
How do i write this following statement in set analysis,
sum(total if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND STAGE<> 'Lost' AND STAGE <> '-' AND STAGE <> 'Expired' AND STAGE <>'Design Win' AND STAGE <> 'Project Cancelled',TOTAL_VALUE))
Thanks,
Bikash
can y try this one
sum({<FACT_TYPE={'Current'},FLAG_HEALTH_REPORT={1} ,STAGE-= {'Lost','-','Expired','Design Win','Project Cancelled'} >}TOTAL_VALUE))
can y try this one
sum({<FACT_TYPE={'Current'},FLAG_HEALTH_REPORT={1} ,STAGE-= {'Lost','-','Expired','Design Win','Project Cancelled'} >}TOTAL_VALUE))