
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set analysis with MakeDate
Another set analysis problem. [:P]
To validate I've added
if(MakeDate(Year, num(Month),Day)<= Date(Today()),1,0)
in the table and it evaluates as expected.
Unfortunately this set analysis expression doesn't:
=Sum({$<MakeDate(Year,num(Month),Day)={'<=$(=Date(Today()))'}>} Budget_ValueSEDay)
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can do something like this:
left join (YourTable)
Load *,
if(MakeDate(Year, num(Month),Day)<= Date(Today()),1,0) as YourFlag
resident YourTable;
After this you can use "YourFlag" field in your expression:
=Sum({$<YourFlag={"<=$(=Date(Today()))"}>} Budget_ValueSEDay)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You Set expression is not correct. Instead of "MakeDate(Year,num(Month),Day)" you should use a Field name which you want use for a selection.
Check the syntax:
set_modifier ::= < field_selection {, field_selection } >
field_selection ::= field_name [ = | += | ¬-= | *= | /= ] element_set_expression
element_set_expression ::= element_set { set_operator element_set }
element_set ::= [ field_name ] | { element_list } | element_function
element_list ::= element { , element }
element_function ::= ( P | E ) ( [ set_expression ] [ field_name ] )
element ::= field_value | " search_mask "

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can do something like this:
left join (YourTable)
Load *,
if(MakeDate(Year, num(Month),Day)<= Date(Today()),1,0) as YourFlag
resident YourTable;
After this you can use "YourFlag" field in your expression:
=Sum({$<YourFlag={"<=$(=Date(Today()))"}>} Budget_ValueSEDay)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your responses.
The syntax was of course not correct - but it would have been great if my expression woule have evaluated.
Now I create the Date in a load script.
