Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ahmedwank
Contributor III
Contributor III

set analysis

hi all

 

i dont understand where is my mistake when i defined a very basic set analysis with a constraint in it  

see picture attached

 

many thanks in advancepic1.JPGpic2.JPG

 

 

 

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

You cannot give =1 when using a field with Total qualifier, it will be a syntax error. You may want to do like this

=Sum(TOTAL <[cat final]> {< [cat final] = {1} >} ligne)

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

You cannot give =1 when using a field with Total qualifier, it will be a syntax error. You may want to do like this

=Sum(TOTAL <[cat final]> {< [cat final] = {1} >} ligne)
jonathandienst
Partner - Champion III
Partner - Champion III

Or this (depending on exactly what the OP wants):

Sum({<[cat final] = {1}>} TOTAL ligne)

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein