Two ALMOST the same queries, different results.

[keesbuth]

Hi.

I am fairly new to DataView. Created some queries without problem, but this one baffles me:

I have note with numbers andf I wnat to show the numbers. This works using:

Table WITHOUT ID Nr, Grief, "[["+Titel+"]]" as "Kort", Onderwerp, Bedrag
From "Prive/- Acties" AND #Scheiding/Beroep AND !#Scheiding/Beroep/Secundair
SORT Nr
WHERE Status=this.Status-Filter

It shows 7 notes. As expected.

But it does not format the numbers. So I changes it. to:

Table WITHOUT ID Nr, Grief, 
rightAlignStyle + "[["+Titel+"]]" as "Kort", Onderwerp, regexreplace(string(round(Bedrag)), "\B(?=(\d{3})+(?!\d))", ",") as bedrag
From "Prive/- Acties" AND #Scheiding/Beroep AND !#Scheiding/Beroep/Secundair
SORT Nr
WHERE Status=this.Status-Filter

So all that is I changed Bedrag to regexreplace(string(round(Bedrag)), "\B(?=(\d{3})+(?!\d))", ",") as bedrag

But now it displays 6 notes.

I figured I should solve this before trrying right align.

Any ideas?

[holroy]

It might be that you're encountering a bug related to if how some functions fail try tegn remove that row from the result set.

In your case this seems related to the round() function which expects a number, and the bedrag field which potentially isn't a number or is empty causing the function to misbehave. What are you trying to do with that regex?

[keesbuth]

That was a great suggestion. The "Bedrag" property on the missing line was type number, it was a number. But I deleted the value, retyped it and there it was!!

What I am trying to do is to make the list more readable. Th thousand seperator is a huge help. Making thee number right align is th missing step.

Very big thanks!!!