How to sum two variables to create a new variable

I am trying to create a new variable from this data, which will be called "Treasury" and will equal the sum of "Net interest income" and "FX margin".

Please could someone suggest how I could go about creating this new variable given the data is grouped by the questionnaire number, also how would I then re-calculate year on year change for this new variable?

Screenshot (53).png

Help

Accepted answers

atcodedog05

Hi @Tom

This one was slightly confusing at beginning and took bit of time 😅

Is it the output you are expecting. "Treasury" sum of "Net interest income" and "FX margin" row

Workflow: I have made some changes in the circles part.

Hope this helps : )

Test Workflow - Revenues.yxmd

All comments

JagdeeshN

atcodedog05

Hi @Tom

Can you provide sample data and expected output.

Something tells me this is not a simple addition 🤔

JagdeeshN

@atcodedog05 @Tom ,

I just re-looked at the screenshot which shows some sample data. Looks like this would need a combination of filter and the crosstab tool, to first get the data in the right shape and then do the addition.

Tom

Here is the workflow, the portion I am working on is off the False tab of the filter tool in the bottom right hand section of the workflow

Test Workflow - Revenues.yxzp

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335