Announcements
cancel
Showing results for
Did you mean:
Not applicable

## If into setAnalysis

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

Guidence is Appreciated..

14 Replies
Partner - Master III

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

Partner - Contributor II

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)

Partner - Champion III

Need a couple more single quotes for vFromDate:

=Sum(

{<

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

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

>}

TranAmt)/1000000

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator III

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

If is working can you mark it as answered ?

Anna