set analysis problem

[#1]

I like to have the budget next to the 'real' value according the correct date

is this possible with set analysis??

[#2]

this is what i would like to have!

[#3 · Accepted solution]

I think the problem is in your date formatting. Use the makedate() function with your input data to make a formatted date value. Your syntax looks sound, but your dates are not being evaluated as dates and as a result, your expression is returning zero.

[#4]

i now have this function but the same result

can you give me a hint how to use the make date??

sum({$<Budget_BeginDate={"<=$(=DATE(Reak_Date,'DD-MM-YYYY'))"},Budget_EndDate={">=$(=DATE(Reak_Date,'DD-MM-YYYY'))"}>}Budget_value)

[#5]

i changed my example with numbers instead of dates and this also not works

can you please have a look at it

[#6]

Jochem wrote:
i now have this function but the same result
can you give me a hint how to use the make date??

sum({tiny_mce_markerlt;Budget_BeginDate={"<=$(=DATE(Reak_Date,'DD-MM-YYYY'))"},Budget_EndDate={">=$(=DATE(Reak_Date,'DD-MM-YYYY'))"}>}Budget_value)
 <div></div>

You have to use makedate during the load script.

Makedate(year, month, day)

So if your input is 01-31-2008, your makedate formula would be makedate(subfield(field_name, '-', 3), subfield(field_name, '-', 1), subfield(field_name, '-', 2)).

[#7]

can you please have a look at the other post (problem2.qvw) because in this example i changed the date to numbers, and this also does not work!

[#8]

Jochem wrote:
can you please have a look at the other post (problem2.qvw) because in this example i changed the date to numbers, and this also does not work!<div></div>

I can't quite figure out what happened in this one, but your syntax is not correct. I think this is what you were trying to accomplish...

sum({$<Budget_Begin = {'<=$(Real)'}, Budget_End = {'>=$(Real)'}>} Budget_value)

[#9]

this is what I was trying to accomplish

real 15 is between 10-20 so budget is 10

real 35 is between 30-40 so budget is 20 etc.