# Can Someone Help?...How To Create Flood Expression in Integromat

Topic Labels: Formulas
3774 12
cancel
Showing results for
Did you mean:
11 - Venus

Hi

I am trying to change the decimal point in some numbers, to be used in Integromat, using ceil or floor options. I tried using the decimal option in GS, but it didn’t work.

Apparently, I need to extract the numerical value, by using split + get functions, then use the math functions floor or ceil. I wondered if someone can help.

I managed to create an expression, with some help, apparently I have to use “String” after ”Split” were “1.value” is, but I was a bit stumped, do I place a value there or use a tag? If it’s a value and I want to change the decimal position from 24.01 to 24, how would I write it? If it’s a tag, we’re would I find it? Also, were do I place the “Temperature: Day” tag?

Thank you,
Mary

This is what I would like to convert:

This is how far I got:

Thank you,
Mary

12 Replies 12
16 - Uranus

Based on your screenshots, I can only see that you’re using Google Sheets and GMail. It looks like the portion of your scenario in question relates to Google Sheets, and not Airtable. This forum is for neither Google Sheets nor Integromat so I’m not sure how much guidance any of us here can give you. I for one am not experienced enough in Integromat’s formulas to provide an answer, sorry.

18 - Pluto

It looks like you’re rounding down in all of your examples, which would use the floor function, as shown in the examples in your first screenshot. The formula in your second screenshot is more complex than you need it. Just put the value from step 3 (i.e. `3. Temperature Day`) inside `floor()`, and it should do the trick.

11 - Venus

I think I did what you suggested correctly, but it did not change the night temperature.

11 - Venus

Mary

18 - Pluto

Your screenshot shows the formula, but obviously I can’t see the before and after values of the data. To confirm that a desired change is really being made, what I’ll sometimes do is make the output a longer string that shows both before and after values, separated by some obvious divider like a vertical bar. If you do that, take a screenshot of that combined output so we can see what (if anything) is happening.

11 - Venus

I tried to do the changes that you suggested. I am not sure if it worked, since it did not move the decimal point.

Here are screenshots: #1 Google Sheets, #2 Google Sheet module, from Integromat, #3 how the results look in my Google email, the day and night temperatures (which are what I am working on) are right after the time.

Thank you,
Mary

18 - Pluto

It worked. All that floor does is drop the value to the nearest whole number. It does not control whether or not the value is displayed with or without a decimal point. The decimal point is driven by that cell’s formatting, not the value put into the cell. As long as the number after the decimal is 0, then floor did its job, and you can change the formatting to get rid of the decimal display.

11 - Venus