Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doubt with set analysis

Hi everybody

i have this function

SUM({<Date= {'$(#vMAxFecha)'}>}Money)

It's working OK

Now i have to ignore selections in "Q"

How i ignore selections in a field? I tried - and {1} but it's not working.

Regards

1 Solution

Accepted Solutions
Not applicable
Author

Hi Jeremias,

if you just want to ignore the selection of that single field name use

SUM({<Q=,Date= {'$(#vMAxFecha)'}>}Money)

if you want to ignore all other selections use the 1 solution Robert provided

hope that helps

Joe


View solution in original post

4 Replies
robert_mika
Master III
Master III

try

SUM({1<Date= {'$(#vMAxFecha)'}>}Money)

alex_millan
Creator III
Creator III

Perhaps,

SUM({<Date= {'$(#vMAxFecha)'}, [FieldName]=>}Money)


Regards,

Not applicable
Author

Hi Jeremias,

if you just want to ignore the selection of that single field name use

SUM({<Q=,Date= {'$(#vMAxFecha)'}>}Money)

if you want to ignore all other selections use the 1 solution Robert provided

hope that helps

Joe


Not applicable
Author

Hi Jeremias

Using {1} will ignore selections in all fields.

If it just selections in "Q" you want to ignore, then try the following

SUM({<Date={'$(#vMAxFecha)'},Q=>}Money)