Good morning,
I am working on a calculation but I am not sure how I can get it to round the result up. Here is the calculation:
OBSNOW("PEFLM %P",str(VAL(OBSNOW("PKFLOWTO")) /
VAL(OBSNOW("PEF PREDICTE"))*100))
This will give me the result of "85.56" or something like that I need it to only give me "86".
Is there a way to do this?
Thanks!
-Alex
OBSNOW(“PEFLM %P”,str(round(VAL(OBSNOW(“PKFLOWTO”)) /
VAL(OBSNOW(“PEF PREDICTE”))*100,0)))
I think I got the parenthesis correct, but round(value,#decimal places) is what you are looking for
Thank you I was entering all in the wrong places. This worked! 🙂
Simple solution, use round(value,point) function, where value=number to round (must be value not string), and point=number of places after afthe decimal point.
The help file for data symbols can be accessed easily: click "Help", click Contents tab,->Administrators and management->Use data symbols->Symbols listed alphabetically.