Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
num(count({<[Request Type]-= {'applied'}>}ISSUED),v_NumberFormat)
num(count({<[Request Type]= ,applied={'applied'}>}ISSUED),v_NumberFormat)
tell me differences between
[Request Type] - = 'x'
[Request Type]=, applied=,requested=,
Hi Manoj,
[Request Type] - = 'x' --> Means all the values of field [Request Type] except 'x'
[Request Type]= ---> Means the expression will not be impacted or change if you select any values under field [Request Type]
Br,
KC
I would recommend you to go through this to learn more about set analysis.
Set Analysis: syntaxes, examples
[Request Type]=, // ignore selection in [Request Type] field
[Request Type] - = {'x'} // consider current selection of the field [Request Type] excluding value 'x'
applied=,requested=, // had they been field, it would have meaning like in the first line explained
[Request Type] - = 'x' --> Means all the values of field [Request Type] except 'x'
This is not exactly correct. First, it would be, like: [Request Type] - = {'x'}.
And, when you put negation symbol ('-') before '=' sign, that means, the value(s) in the list (within curly braces) would be excluding from the set taking into consideration - the current selection. However, if you put the negation symbol ('-') after the '=' sign, like: [Request Type] = -{'x'}, it means, like you said : all values (irrespective of selection in the field) except 'x'.