IF statement

[#1]

Hi,

How is in the set analyse with if statement

if(only select on Year and Month in Calendar, then sum(Value).

Thanks

[#2]

Why not use IF()? You don't need to define a set, just use a conditional statement.

[#3]

Hi,

i have 2 variable.

varstartdate

varenddate

how can i in statement the sum(value) from range varstartdate and varenddate become.

(>=varstartdate and <=varenddate sum(value))

Thanks

[prieper]

SUM(IF (YourDate > StartDate AND YourDate < EndDate, Values)=

HTH
Peter

[#5]

Hi,

Thanks, sorry but it is not what i want.

i want the sum of Valuse in range from StartDate and EndDate, when i select the Calendar Year and select the Calendar Month

i have as Variable :

Startdate:

=Date (num(monthsstart(1,[Calendar.Year-Month] ,-12)))

Enddate:

=Date (num(monthsend(1,[Calendar.Year-Month] ,1)))

and Statement :

sum({<Calendar.Date ={">=$(=(Startdate)) <=$(=(Enddate))"}>} Sales)

but it is comming Sales from selected Year and month, not in the range from Startdate to Enddate.

is the formel not correct?

Thanks