Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!!
I have a table with three fields: ID, TIME1, TIME2 , USE1, USE2. And a table with the dimension ID, and the expression Sum(TIME1) + Sum(TIME2). But I only want the expression to sum TIME1 if its related USE1 is not 'INTERN_USE' and to sum TIME2 if its related USE2 is not 'INTERN_USE'. How can I write this expression?
Thanks!!
Júlia
SUM({<USE1 -= {'INTERN_USE'}>}TIME1) + SUM({<USE2 -= {'INTERN_USE'}>}TIME2)
if already tried this but it doesn't work:(
Provide sample file or sample application.
ok you have it, its a little bit different than the question because I hoped it would exist an easy way.. You will see that I have three charts, related in different ways. I'll like that in the table the second, third and fourth column (Sum of fields) sum without the item 'Uso_Interno' in the field Etiquetas