Hey there
I had a quick question around NetSuite "Utilization by Resource Report".
The requirement is to edit the UTILIZATION Column formula in the "Allocated Utilization by Resource Report". Currently, it's calculated as Allocated Time by Available Hours, we need to change it to Allocated Time by Net Hours. (image attached) As far as I know, we cannot use one formula field output to create another formula field in NetSuite Reports. Is there a way around this?
ALLOCATED UTILIZATION BY RESOURCE REPORT
When I look at the "Actual Utilization by resource report" and customize, it uses the "Net Hours" field. I thought I can use this Net Hours field in the "Allocated Utilization by Resource Report" but when I try to search for the "Net Hours" field it does not show up in the Search Field Section, even though it states its under Time Tracked: Net Hours (Image attached). I am assuming the Net Hours field is not exposed. Can we expose it?
ACTUAL UTILIZATION BY RESOURCE REPORT
Any idea why I cannot find this field? So now I have two issues:
- How to calculate Net Hours and use it in Report?
- How to find the Net hours field used in "Allocated Utilization report"
Any help would be appreciated.