I need to categorize sets of data by actual, PY and budget without duplicating the data. My formula below is able to split Actual/PY successfully.
=If(substr(userresponse(enter.....) = right(year); actual;PY.
However I need budget piece and its coming up as actual with formula above. So I decided to use an indicator from the budget universe (Budget data coming from a different universe)
=If(Left([Object Key];4) = "BAG";"Budget"; If(Substr(UserResponse("Enter...Year)");5;4)=Right([FYPeriod - Key];4);"Actual";"Prior Year"))
The 2nd formula then causes duplication of the actual/prior data. Please see screen shot to see all 3 formulas I have tried and the result.
APPRECIATE ALL THE HELP!!! Thank YOU!!!
Hi,
I can only see the formulas from the screen shots. Can you post screen shot of column names?.
I'm not clear what you are trying to get.
Thanks,
Jothi
Add comment