Here's a demonstration of how to create a rounding up or rounding down math function.

Transcript:

To create a derived answer, I click smart answer, choose derived, leave it on free form, and that allows me to create any fields or anything else I want in that answer. Then this derived answer is gonna be a sum of question one and question two. So I add a field here and insert a field based on question when, treat it as a number so that I can perform a math calculation on it by clicking the math tab.

And the math formula I want here is field one as my starting point plus I'll click the plus there.

And what do I wanna add to it? I want to add field two.

So there's my formula. It's gonna take the sum of field one, field q one, and field q two and give the answer right there in the derived answer. Let's just test what we've got so far, and then we'll get into the rounding portion of this. This is gonna be a regular text answer.

So let's suppose my first answer is three four five six seven eight nine.

Let's put in a portion of that number in this answer. I'll do the three million here, and then I'll do the rest here. Four five six seven eight nine. So our derived answer at this point should be three million four hundred fifty six thousand seven hundred and eighty nine when I click the fill button, and that part is working so far. Now let's suppose you wanted to present in your form a rounded off amount to the nearest hundred thousand.

So our ultimate answer up here let's put this all on one page so we can see everything at once.

The rounded sum is to the nearest one hundred thousand is some value here. And you have two approaches here. I could modify this field down in the derived answer so that it provides the rounded sum and then just put a simple field up above here that pulls in that that amount.

Or I could leave this derived answer as is, supposing that I might wanna use that more accurate number elsewhere in the document. And up here, create a field that is gonna round off that value just for its presentation at this point in the form. And that's what I'm gonna do here in this case because that gives me more flexibility. That way, elsewhere in the form, I can still refer to the the the the more detailed, more accurate number if I need to. So up here, I'm adding another field.

It is gonna be the derived answer field. Insert. And if I just left it at that, it would give me three four five six seven eight nine, But I want to round that off to the nearest hundred thousand. So I'm gonna click number to treat it as a number field. That gives me access to the math tab again. I'll click math to get it into my math formula creator, my math screen.

And this time, I need to figure out a formula that is gonna turn three four five six seven eight nine into three million four hundred thousand.

And I've done this before, so I ought to be able to do it now. I know that what I'm gonna wind up with is this number divided by a hundred thousand and then just take the integer portion of that result and then multiply it by a hundred thousand, and I think that will be clearer to you as we work through it. I'm gonna start out with in fact, I'll just do it in stages here so that you can see what I'm doing. First, I'm gonna take the value that we start with, which is the field derived answer.

So that's gonna be our starting value. In this case, three four five six seven eight nine.

And I'm gonna divide that by one hundred thousand. Oops. I got extra space. Thousand. Oh, I did something wrong here already, and I'm gonna go ahead and leave it that way so you can see what happens.

I typed field drive answer divided by a hundred thousand. Notice I put a comma in there. When I click okay, it tells me the selected character is not allowed at this location.

Look at where the cursor is right there on the comma. That's telling me the comma is not allowed in math formulas. So I'm gonna delete that comma, and then I'm gonna click okay.

And that's gonna we're not all the way there yet. All that's gonna do is divide it by a hundred thousand. I want you to see what that result is before I go further. And when I fill that in, I end up with thirty five.

Okay? That's because let me reset it again. That's because it has divided three four five six seven eight nine by a hundred thousand, which came up with thirty four point five six seven eight nine. And then it's getting rounded off to thirty five because let me go into my field in here. Because my format in this field is set to be no decimals, that means it's gonna round off any decimal places and give me a a whole number.

If I change that to say flexible decimals and recalculate, then you can see a more accurate representation of what's happening so far.

So far, what I've done is divide by a hundred thousand. My next step is going to be to truncate this number so that the five six seven eight nine get removed, and I'll show you how to do that.

And I will reset here. And I'm gonna modify this math formula. I click the field button to get back into the field screen. I click the math tab to get back into my math formula by clicking that pencil icon down in the corner. That's to edit the formula.

Back in my formula here, the way to truncate a decimal number, to to just chop off the decimal portion of a number, is to use the integer function.

Let me show you that. I'm putting my cursor at the front of the field here and clicking integer plus, a little plus icon to add my integer function.

And the integer function wants me to put something right there where the cursor is flashing, and what I need there is all of this stuff. When you get into this situation where you need to actually edit an existing formula, you could delete this material and then insert it over here where it belongs, or I'm gonna get a little bit tricky here. I'm gonna unlock the editing box by clicking that little padlock icon, and it's telling me now I now I'll be able to use control c to copy and control v to paste, which is what I'm after. I'll say yes. And now it turned this box into more of a free form editing box so that I can actually grab text, cut it from one place with control x, and paste it in another place with control v. It's easier to make mistakes when you're in this mode because the program is not helping you by making sure you don't put something in the wrong place.

But at times when you wanna just grab something and move it somewhere else, it's really handy. So now what I've what I've got is an outer function. My integer function says, take everything in here and chop off the decimals, leaving us just with the integer portion of that number. I'm gonna click okay, and we'll see what we've got so far.

We're seeing background noise now. A little background noise. If someone is able to mute themselves, that would be good. And now when I click fill, our result is thirty four.

So we're very getting very close.

At this point, we wanna take the number we've got, thirty four, and multiply it by a hundred thousand, and then we're gonna end up with our rounded sum.

I'll click reset and go back into that field by clicking the field button. Go to my math tab. Click the pencil icon to edit it, and all that's left is to multiply this by one hundred thousand.

Okay.

And and see my results.

And it doesn't have commas in there. Let me reset that and change my formula or my format rather. Click the field button.

Change my format to something with commas so it's easier to read.

Click fill again.

And that's what I want. Well, I realized, actually, that's not what I wanted to wind up with. What I did there was rounding down.

If you always want to round that number down to the nearest hundred thousand dollars, that's the way you do it. In this case, though, I actually want to round it to the nearest hundred thousand dollars. So I'm gonna do this a little bit differently. Let's leave that one. I'm gonna copy thatOkay. Copy. Oh, wow. That's interesting. Going to paste it here and do a variation of it.

This is this is rounding to the trust administration. Rounding down. They went up. They just wanna have The sum rounded from our plan is down to the nearest hundred thousand dollars is that one.

And then now let's do one that's gonna round the sum around the helps me to years. Remember my plan? Hundred thousand, whether it's up or down, and I'll have to make some changes here to make that work. On this one, I think we've actually started out with this, and then I modified it.

I'm gonna go back into the field here. What we want to accomplish the rounding will be we're gonna need a drive answer here. Okay.

I'm gonna delete that, so we're starting fresh. What I'm gonna do is first I'm gonna create a truly rounded number, one that will round either up or down in a second derived answer. Let's add a derived answer. This will be rounded I'll call it round near or the nearest rounded number. It's also a derived answer, and it's gonna be a field.

I'm sorry. It's gonna be a smart answer, a derived smart answer reform.

Now I can add a field to it.

This field is gonna grab the original number from the derived answer, the the d e r a n s answer.

I will insert that field, and then it's going to divide it by a hundred thousand and present that result rounded. It should give me thirty five. So I click number to treat it as a number, choose the math tab to create my formula. I want to divide that number by one hundred thousand.

And then in my format selection here, make sure I have chosen no decimals. That's what's gonna do the rounding for me. Click done. And when I click fill, let's see if we got thirty five like I want. We do. That's good. We're correct so far.

I will reset.

Given that thirty five in my second derived answer, I can now create a field up here which is gonna multiply that second rounded number by a hundred thousand to give me the result I want. So I add a field, choose my sec my round near answer. That's the one that has thirty five in it.

Treat it as a number so that I can get to my math tab.

And this number, which is gonna be thirty five when it's down below here, I want to multiply by one hundred thousand.

Okay.

Done. See if that gives us what we're after.

That's good. Now we'll test it a little bit. So far, we've got this number here, three four five six seven eight nine, being rounded down to thirty four hundred thousand dollars and being round to the nearest, thirty five hundred thousand dollars. What if this value were three four three six seven eight nine? We should get a different result up above. I'll click fill.

Now the top one, which gets rounded down always, is going to whoops. Oh, I I made a silly error here. Instead of changing this answer, I changed the derived answer, which had no effect because the derived answer just got recalculated again. So instead, I want to make my change here. We want three four three six seven eight nine.

Now I'll click fill, and now we get good. Our value that is rounding down went down to thirty three million four hundred thousand just like before, but now our number which is rounding to the nearest also went down instead of going up like it did before. So now I know that both my rounding down is working and my rounding to the nearest is working.

^{tags: round, integer, truncate}