issue with the values

[Anonymous]

am encountering an issue in one of my application:

i have 3 text boxes:

first is displaying sum(x)

x is a field

second is displaying

sum({$<y={'N'}>}x)

y is another field which has values Y and N

third text box displaying values :

sum({$<y={'Y'}>}x)

so ideally the value displayed in the first text box shud be the sum of secnd and third text boxes

but its not happening,

what cud be the reason?

how i shud start digging into the problem means from where scirpt,front end selections etc,

kindly help and guide.

[tresesco]

This could be because your y field has few NULL values or some non-'X' or 'Y' values.

[jduarte12]

Do all the entries in x field have a match with 'Y' or 'N'?

[neha_shirsath]

Check for null values in y field.

[Anonymous]

how to achieve the same

[Anonymous]

i took x and y in a table box,i can see for some y values ,x values are showing null

and den i also tried to poulate some y values in x values

for eg:

  if(len(x)=0,'Y',x) as field1,

but no result out of this

and also there is one more expressions used:

other field with y field then again the same issue,

so there is some issue with this y field?

[neha_shirsath]

try with this-

=if(WildMatch(X,'',' '),'Y','X') as Field1

[tresesco]

Try like:

If( len(trim(x))=0, 'Z',x) as newX

If this doesn't help, try to share a sample qvw that depicts the issue.

[sasiparupudi1]

sum({$<y={'*'}-{'Y','N'}>}x)  to get null count

[tresesco]

'*' doesn't include null values.