Calculated Field - weird format

[toms]

Hi,

There's a calculated field (input type: number) in a subform. The expected output should be 193.2. What's going wrong?

[admin]

toms,

I can't think why.

If you uploaded a stripped down copy of your db (with just the problem bits in it) I could take a look for you.

Steven

[toms]

Steve, thank you for offering your help. Let me just give you some more details first. I noticed that there is a N| prefix. When I remove it in the developer console, the format of the calculated field will look alright.

[admin]

toms,

That N| is supposed to be there (N| is for numbers, D| is for date formats).

Have you created any of your own Formats and tried them?
http://wiki.nubuilder.net/nubuilderfort ... at_Builder

I cannot reproduce the problem.

I'm happy to look at your db.

Steven

[toms]

Have you created any of your own Formats and tried them?
http://wiki.nubuilder.net/nubuilderfort ... at_Builder

Yes, I created my own format. It looks like this:

input_type.png

This is what's happening behind the scenes. The variable m = "1000 13i000" and this is exactly what I see in the calculated field.

format_number.PNG

The subform and calculated field:

calc_field.PNG

[admin]

toms,

Try putting a sign in front of your formats (you can arrow up and down to choose from some defaults).

format_sign.png

It's a bug that needs fixing but try that.

Steven

[toms]

Adding a sign doesn't help either.

adformatting.PNG

$1000.PNG

[admin]

toms,

You have changed the Format but you may need to reselect it in the Edit Form.

The 2 things are not automatically linked.

I will fix the dodgy field position problem in Format too sometime.

Steven

[toms]

You have changed the Format but you may need to reselect it in the Edit Form.
The 2 things are not automatically linked.

This is what I did. For now, I just set no format at all since this works.

[admin]

toms,

I believe I have fixed the problem you were having now - latest Github.

Steven