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

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.

Thanks in advanced.

1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

Hi!

Two calculated measure might do it?

 

[measure1]

IF reference = 1 then recieved

ELSE .

 

[measure2]

IF reference = 2 then recieved

ELSE .

 

 

//Fredrik

View solution in original post

2 REPLIES 2
FredrikE
Rhodochrosite | Level 12

Hi!

Two calculated measure might do it?

 

[measure1]

IF reference = 1 then recieved

ELSE .

 

[measure2]

IF reference = 2 then recieved

ELSE .

 

 

//Fredrik

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 2054 views
  • 3 likes
  • 2 in conversation