If into setAnalysis

[#1]

Expression-

SUM(IF((TranTyp = 'CO' OR TranTyp = 'CB' OR TranTyp = 'DR' OR TranTyp = 'RC' OR TranTyp = 'BP' OR TranTyp = 'TR' )

     AND TranDt>=$(vFromDate), TranAmt))/1000000

Can anybody help me convert in to setanalysis

Thanks In Advance

Guidence is Appreciated..

[shubham_singh]

Sum(

{<

TranTyp = {'CO','CB','DR','RC','BP','TR'},

TranDt={">=$(vFromDate)"}

>}

TranAmt)/1000000

[#3]

Thanks Shubham Singh ,

when i pasted this in expression editor, it is showing

"THE SELECTIONS GENERATED NO DATA FOR THIS CHART "

why is like this , any further investigation ppleasee

Help is appreciated

Thanks in Advance

[#4]

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))

can u convert this in to setanalysis shubum please..

[Anonymous]

SUM ( {<TranTyp='CB',TranDt={'>=$(=Date(vFromDate,'MM/DD/YYYY'))'} >}TranAmt)

/

Aggr(Sum({$<TranDt={'>=$(=Date(vFromDate,'MM/DD/YYYY')))<=$(=Date(Today,'MM/DD/YYYY')))'}>},

        {$<DemandDate={'>=$(=Date(Monthstart(Min(TranDt)),'MM/DD/YYYY'))<=$(=Date(MonthEnd(Max(TranDt)),'MM/DD/YYYY'))'}>}      DemandDate ), DemandDate )

[shubham_singh]

Try adding an equal sign just before expression of variable vFromDate.

If that doesn't work share your vfromdate expression or a sample app.

[annafuksa1]

SUM({<TranTyp = {'CO' , 'CB' ,'DR' , 'RC','BP','TR' }, TranDt ={">=$(vFromDate)"}>} TranAmt)/1000000

[shraddha_g]

How did you declare vFromDate?

[#9]

DATE(IF(vFrequency = 'Y',DateCurrYearStart,

IF(vFrequency = 'Q',QuarterStart(TodayNum),

IF(vFrequency = 'M',MonthStart(TodayNum),

IF(vFrequency = 'D', Today)))))

[#10]

Above is the vFromDate