Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
Where do I write wrong. What I want to achieve is to first make sure you start from the current period + that a field should be OnG.
Then everything must be counted from current and 6 months back.
It claims that there is no parenthesis.
Code:
RangeSum (below (Sum ({<[Period] =>} [EmpF] = {'OnG'}), [DepA] =>} [Nrb_Emp_ex]), 0.6) /
RangeSum (below (Sum ({<[Period] =>} [EmpF] = {'OnG'}), [DepA] =>} [Nrb_Emp]), 0.6)
Bothe rangesum() are missing their closing brackets and below() expects integer as parameter. Also the set analysis syntax isn't correct because you tries to add multiple sets but not connecting them in an way. Your expression might be therefore looking like:
RangeSum (below (Sum ({<[Period] =, [EmpF] = {'OnG'}, [DepA] =>} [Nrb_Emp_ex]), 0, 6)) /
RangeSum (below (Sum ({<[Period] =, [EmpF] = {'OnG'}, [DepA] =>} [Nrb_Emp]), 0, 6))
- Marcus