Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This could be because your y field has few NULL values or some non-'X' or 'Y' values.
Do all the entries in x field have a match with 'Y' or 'N'?
Check for null values in y field.
how to achieve the same
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?
try with this-
=if(WildMatch(X,'',' '),'Y','X') as Field1
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.
sum({$<y={'*'}-{'Y','N'}>}x) to get null count
'*' doesn't include null values.