Is it possible to link two questions together in a report

Follow
Avatar
Jon Collis

I spend a fair bit of time each month doing the bordx, I could save myself some time if I could link questions together.

 

For example on the liability quotation, the main trade might be 'other' but then the trade is described in another question as 'IT Consultant'. I want to be able to put 'Other - IT Consultant' on the bordx.

 

 

4

Comments

1 comment

Sort by Date Votes
  • Avatar
    Mark Williams

    Hi Jon, try this:

    IF([AdditionalTradeDescription].Replace(' ','').Length > 0,[Trade] +' - ' +[AdditionalTradeDescription],[Trade])

    This will see if the additional trade description contains any data (except spaces which are stripped out). If it does contain tata it will be appended to the end of the trade question with a hyphen.

    You will need to put this in a "Formula" type field in your report.

    Let me know how this goes.

    Best regards,

    Mark

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post