Format Repeating Group Text as Integer

Need help App Organization
1

Dear Bubblers,

Please I need help on how to format my repeating group as integer.
I have a thing in the database that the value is an average of items.

I get values like 7.1112334, how can I format the text on the RG to 7?

image
image1327×196 3.18 KB

Or better still round up or down?

Thank you all.

2

:ceiling

1 Like
3

:slight_smile:great. Worked like a charm!

4

I need your help on this thread topic please.

5

you was already given good advice, try follow that.

6

Thanks. Unfortunately I cannot seem to get it to work.
Breaking down the workflow is a challenge, I ended up messing up the entire app.

Poor me…

7

its because you are writing lots of data too, not just the searches.

Uhh rethink your logic, stock replenishment can be loaded in a state instead of db and update that state whenever workflow is completed. Sales man average sales isnt so important to calculate it every sale, can do that on a button click or end of the week type thing.

your method looks too complicated, tell me what you are trying to build (in very simple terms) and i will redesign it for you when i get the chance.

8

Thanks for your time.

Summary of app: Its a 3 in one app, a stock management app and a sales recording app and replenishment generation.

  1. I have a product, whenever the customer sells, the stock database is reduced by the quantity sold, the sellout db is updated with the quantity sold so I can get an average. When the stocks reaches a limit, I can generate a replenishment, that’s the entire summary.