Skip to Content

SPLIT categroy by text

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)
Add comment
10|10000 characters needed 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

  • Get RSS Feed

0 Answers