Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem that occurred after I upgraded to QS June 2018.
My Data is like:
Document,Number
100,1
200,2
300,3
400,
500,5
600,6
700,
800,8
900,9
With QS February 2018 the expression Count({<Number-={'9'}>}Document) would return 8. Yesterday I upgraded to June 2018 and reloaded the data (I did not make any change in the data file or the app). Now the same expression returns 6, i.e. totally ignoring the lines with no Number value as if they do not exist. If I change the script to IF(LEN(TRIM(Number))=0, 'Missing', Number) AS Number
then the expression returns 8 again.
Also, with the previous release, the expression Count({<Number={''}>}Document) would return 2. With QS June 2018 it returns 0 and works again only after the change in the script mentioned above.
Is this a bug in this version or what is going on?
Hi Steve,
Can You attach an example Excel file?
//Lucke
Hi Lucke,
Please see attached the file used for the example in my second post.