Skip to Content

Combine formula to read as text - multiple queries involved HELP

I have formula below to help me identity actual and PY. I need budget piece inclusive and am trying to modify formula to reference the budget.

=If(substr(userresponse(enter.....) = right(year); actual;PY.

I am able to identify actual and prior year with above formula. My budget is pulled into report from another query with similar userresponse prompt and because my budget is actual. The formula is picking it up as actual too.

I need help to,identify budget data as budget. How do l modify the formula to reference budget as budget. I have an object with key word *Bag* that, l believe can help single,out,the budget data...how do l get this done using unique identifier? I need formula modified, keeping in mind the merged query.

Thanks much. Really do need this URgently.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 19 at 01:09 PM

    in case of multiple queries create detail variables and associate them with merged object for which you have used in the formula and try.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 19 at 01:45 PM

    Hi Amit - not sure I understand what you saying, please look below. I tried using the AND function to combine below but error. CAn you assist in revising? Will appreciate this, thank you

    =If(Substr(UserResponse("object)");5;4)<>Right([object];4);"PY" AND (Substr(UserResponse("object)");5;4)=Right([object];4) And [object] InList ("Ball";"Not") ; "Bud";"Act"))

    Add comment
    10|10000 characters needed characters exceeded