J
JamesM
Hello,
I hope someone can help me out here. I am creating a PA view with Resources
listed down the left and Time along the top. The data area shows work values
on a day by day basis.
Now what I want to do is say that anything less than 1h of work should be a
zero unit value in a custom formulae field called FTE ( for example). Any
value over or equal to 1h, but less than 5h work is considered to be 0.5
unit, Any value over or equal to 5h is 1 whole unit value.
How do I set up a formula so that these valuse are calculated in an OLAP
view and displayed on a day by day basis ?
Thanks
James
I hope someone can help me out here. I am creating a PA view with Resources
listed down the left and Time along the top. The data area shows work values
on a day by day basis.
Now what I want to do is say that anything less than 1h of work should be a
zero unit value in a custom formulae field called FTE ( for example). Any
value over or equal to 1h, but less than 5h work is considered to be 0.5
unit, Any value over or equal to 5h is 1 whole unit value.
How do I set up a formula so that these valuse are calculated in an OLAP
view and displayed on a day by day basis ?
Thanks
James