Set analysis formula

[#1]

hi i would like to combine a  if statement and set analysis or rewrite the statement into set analysis.

SUM(if(Date2>=DateFrom and Date2<=DateTo,

{$<#Dat_O ={'1'}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act))

at the moment i am experiencing syntax problems with this statement.

help is greatly appreciated.

Brad

[jagan]

Hi,

Is DateFrom and DateTo are variables?  If yes, then use this

=Sum({<Date2={'>=$(=DateFrom)<=$(=DateTo)'}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act)

If they are datefields, then try if there is any ID field then use this, replace ID with your ID Fieldname

=SUM(Aggr(if(Date2>=DateFrom and Date2<=DateTo and [#Dat_O] = 1, OrderRad.NettoBelopp * OH.Kurs_FSG_act), ID))

Regards,

Jagan.

[preminqlik · Accepted solution]

according to your expression try this

SUM({$<#Dat_O ={'1'}>}if(Date2>=DateFrom and Date2<=DateTo,

OrderRad.NettoBelopp * OH.Kurs_FSG_act))

and also try this

Sum({<Date2={'>=$(=DateFrom)<=$(=DateTo)'},Dat_O ={'1'}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act)

[preminqlik]

if your DAt_O is in number then use this

Sum({<Date2={'>=$(=DateFrom)<=$(=DateTo)'},Dat_O ={1}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act)