Hello.
I am a fairly new user, and don't even really know if I'm in the right place to find some help, but I need to know where I can find a list of Syntax for developing formula.
For example, I want to develop a report that projects output for a 12 month period based on the current output since a certain date. Let's say that since December 1, 2017 one individual has produced 5,000 Metric Tonnes of material in 900 Actual Work Hours - based on timesheets; to date since that day, he had 1200 Total Work Hours available to him, meaning he actually produced material for 75% of the available time [900/1200=75%] and was not producing (breaks, lunch, etc) for 25% of the time; if there are 1900 Total Work Hours available to him in any 12-month period, he would be producing material for 1900*(0.75)=1425 Actual Work Hours. So his Projected Output would be (5000/900)=>(5.56 MT/Hour)*(1425 Hours)=7916.7 Metric Tonnes per 12-Month Period.
Any ideas on how to write this? Or at least where I can find the Syntax.
Thank you very much for your time.
Jim
PS. Where is the current % of hours worked? Is that a Field? Or the result of a Report Summary Formula? You can't reference a Report Summary Formula result within another Report Summary Formula (if that's what you're trying to do). You'd need to do it in a Formula Field on the Object in the Report, then reference it in your Report Summary Formula
