Summing FROM-TO

[#1]

Hi everybody,

I'm facing a problem where i don't find a way to resolve it.

I'd like to do a sum with two conditions.

What I'd like to do (on my designer) is sum an import from Data_A to Date_B.

Something like:

SUM( {<Date >= $(vFrom) and Date <= $(vTo)  "}>}  Import)

IIs there a way to do that?

Thank you so much in advance.

Giampiero

[jvitantonio · Accepted solution]

Hi, try this:

sum({$<Date={">=$(vFrom)},Date={"<=$(vTo)} >} Import)

[#3]

Thank you so much.

It works perfectly.

I was on the right way but my expression was wrong

sum({<date= {"=date>= $(vFrom) "},date= {"=date<= $(vTo) "}>} Importo)

Again, THANK YOU so much

Giampiero

[christian77]

I don't think so. You can call a field only once in a set.

I use single quotes.

Try this one...

sum({$<Date={'>=$(vFrom)<=$(vTo)'} >} Import)

[#5]

Hi,

Thank you for reply.

Your solution works fine as well as the other one.

Thank you

Giampiero