Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I have to do this.
SUM of "Number"
Concept = 'Concept1'
And 'Installation' has to be emtpy , i mean i don't have to have values in this field.
the two first are this
SUM({<Concept = {'Concept1'} >}Number) |
But how i do the last thing?
Am i clear?
Thank you, greetings!
Is this?
SUM({$<Instalattion={'*'}-{''}, Concept = {'Concept1'} >}Number |
If this is correct. Now i wanna have the same but when Instalattion IS NOT empty
how i do that?
Thanks
Try something like this:
SUM({<Concept = {'Concept1'}, Instalattion -= {'*'} >} Number)
- Marcus
Does your original post mean that installation should be a null value? or you do not want to include it in the expression?
The field 'Installation' has to be emtpy , it dont have to have vallues, null.
It doesn't work!
Without the - i dont have errors
Hope this helps
I didn't understand
what i have to put after the =-?
OK the answer is THIS
Sum({$<SET THAT IS NOT NULL -= {""}>}THIS IS THE OPERATION)