I have built an app that pulls available vacation hours for employees. However, in SQL table for 80 hours it is listed as 8000 and 120 hours is listed as 12000. I am trying to use LEFT truncate function to drop off the last 2 zeros but that doesn't work for both 8000 and 12000. If I do LEFT 2, I get 80 for the 8000 (which is correct) but only 12 for the 12000. Is there a way to truncate both numbers correctly int he same label? Thank you.
Solved! Go to Solution.
I think the way to go here is:
Your database is probably storing the values as integers with the 2 right-most digits for decimal places.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
FIll out a quick form to claim your community user group member badge today!
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!