🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Obsidian | Level 7

## SAS VA - How to create aggregated measure by column value

Hello community, I'm having a lot of trouble finding the solution to my problem, I hope you can help me

I have a table that was created from a union, example:

ID    RECEIVED    PAID    REFERENCE

0         100                50                1

1         200                60                1

2         300                70                1

3         400                80                2

4         500                90                2

I'd like to create an aggregated measure that takes all RECEIVED values ​​that have reference equal 1, and another measure for equal reference 2. I've tried several ways to get these measures but I did not succeed.

1 ACCEPTED SOLUTION

Accepted Solutions
Rhodochrosite | Level 12

## Re: SAS VA - How to create aggregated measure by column value

Hi!

Two calculated measure might do it?

[measure1]

IF reference = 1 then recieved

ELSE .

[measure2]

IF reference = 2 then recieved

ELSE .

//Fredrik

2 REPLIES 2
Rhodochrosite | Level 12

## Re: SAS VA - How to create aggregated measure by column value

Hi!

Two calculated measure might do it?

[measure1]

IF reference = 1 then recieved

ELSE .

[measure2]

IF reference = 2 then recieved

ELSE .

//Fredrik

Obsidian | Level 7

## Re: SAS VA - How to create aggregated measure by column value

Thanks a lot bro!
Discussion stats
• 2 replies
• 1894 views
• 3 likes
• 2 in conversation