Skip to Content
0

SPLIT categroy by text

Feb 19 at 01:04 PM

44

avatar image

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!!!

txt1.pngtxt2.png

txt1.png (151.3 kB)
txt2.png (74.8 kB)
10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers