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

[shraddha_g]

Try

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

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

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

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

Also check format of TranDt i.e whether it is Number format or Date, if in Date what is exact format

[ayandey18]

Try it,

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

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

[jonathandienst]

Need a couple more single quotes for vFromDate:

=Sum(

{<

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

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

>}

TranAmt)/1000000

[jonathandienst]

Or change vFromDate to a number (replace the Date() statement):

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

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

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

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

[annafuksa1]

if any of the propositions is not working can you post your app ?

If is working can you mark it as answered ?

Anna