Sage 100

2015 Advanced. VI job. I have a temp numeric field that I want to limit to 2 decimal places. What is the syntax for a numeric mask? This is the formula I believe should work yet it generates an error 20 (syntax error). ({PR.DATAENT.HOURS_RECT_AMT}*{PR.DATAENT.RATE}):""#,###.00

prc({PR.DATAENT.HOURS_RECT_AMT}*{PR.DATAENT.RATE},2)

Thanks Beth. What's the PRC directive? Percent?

I found it. PRC is precision. Worked like a charm. Thanks a million.

Yay!

Or Precision Rounding Calculation. You choose. A great resource for those that have not found it is http://manual.pvxplus.com/. Go to Language Reference - System Functions. Your VI Functions will thank you.

Yes, the dreaded PR VI import without a PRC will indeed cause a massive PITA downstream

I know the manual well. Thats where the mask directive that didn't work in my vi job is documented.