topic Re: can anyone write in Setanalysis in App Development

can anyone write in Setanalysis

Thu, 16 Mar 2017 10:36:54 GMT

count(if(AgentOrDist='A',AgentID))/count(TOTAL <[Zone],[Region],[Cluster],[JC]> if(AgentOrDist='A',AgentID))

Hello everyone ,

Help me write in setanalysis,

Thanks In Advance

anushree1 — Thu, 16 Mar 2017 10:47:57 GMT

Try This:

=count({<AgentOrDist={'A'}>}AgentID)/count(TOTAL <[Zone],[Region],[Cluster],[JC]> {<AgentOrDist={'A'}>}AgentID)

Mon, 20 Mar 2017 12:44:38 GMT

Anychance we can right this in setanalysis

if(vJCFactor=1,

COUNT(DISTINCT IF(aggr((sum(if(TranDt>=$(vFromDate) AND TranTyp='CO',TranAmt))/SUM(AGGR(if(DsbrDate>=$(vFromDate) and DsbrDate<=Today

AND DsbrDate >= MonthStart(min(TranDt)) and DsbrDate <= MonthEnd(max(TranDt)), SUM(DisbrAmt)),DsbrDate,JC))),JC)>=.5,JC)),

if(vJCFactor=2,

COUNT(DISTINCT IF(aggr

(SUM(if(TranTyp='CB' AND TranDt>=$(vFromDate), TranAmt))/

SUM(AGGR(if(DemandDate>=$(vFromDate) and DemandDate<=Today

AND DemandDate >= MonthStart(min(TranDt)) and DemandDate <= MonthEnd(max(TranDt)), SUM(DemandAmt)),DemandDate,JC)),JC)

>=.75,JC)),

if(vJCFactor=3,

COUNT(DISTINCT IF(aggr(count(DISTINCT if($(AgntMonthlyComm)>=2500 AND AgentOrDist='A',AgentID))

/count(DISTINCT if(AgentOrDist='A',AgentID)),JC)>=.4,JC)),

if(vJCFactor=4,

COUNT(DISTINCT IF(aggr(sum(if(TranDt>=$(vFromDate) AND TranTyp='DR',TranAmt))/$(vTotalTranAmt),JC)>=.2,JC)),

COUNT(DISTINCT IF(aggr(COUNT(DISTINCT IF(Status='A' and AgentOrDist= 'A',AgentID))

/COUNT(DISTINCT IF(AgentOrDist= 'A',AgentID)),JC)>=.5,JC))))))

CarlosAMonroy — Mon, 20 Mar 2017 12:52:58 GMT

Hi Charlie,

Try:

if( AgentOrDist = 'A', count(AgentID)/Count(Total <[Zone],[Region],[Cluster],[JC]> AgentID))

count({<AgentOrDist = {'A'}>}AgentID)/count(Total <[Zone],[Region],[Cluster],[JC]> {<AgentOrDist = {'A'}>}AgentID)

Hope it helps,

Carlos M

Mon, 20 Mar 2017 13:17:13 GMT

thanks its Helpful, how about the other one?

can you able to write it?