Tabitha DeCaprio's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pace University

Country

Latest Posts

Re: model development
@Mark Oldfield Is there a way to do this via join with a case statement?
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Mark Oldfield Thanks. I need to see the combination of data and be able to slice/dice by many elements that are in the revenue table but not in the financial aid table.…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Mark Oldfield not all of the attributes exist in both tables therefore I had to create columns in the financial aid table in order to do a Union. I need all of the attributes to line up with the…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Mark Oldfield The Union is separating the campus where the tuition is correct by campus but does not join the Aid by campus, just has campus as 0 (should be either NYC, PLV,…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Mark Oldfield Hi Mark. So the total values matched up, now that i've added calculated columns in the second table that the first table has the data is not aligning.…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
Thank you! That worked!!!
- Tabitha_DeCaprio
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: model development
@Moshe Yossef I've been trying to do a work around, but I can't get the case statement to work either... Case( Criteria(NotEmpty([Term_ID]) AND NotEmpty([Tuition_Titles]) AND…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Moshe Yossef you were right but when i tried to fix it it says the column nodes do not match...but when i try to reorder it says they dont match...
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Tabitha DeCaprio How I want it to look Tuition Titles TOTAL_Revenue TOTAL_Aid None - 500,000 Other Tuition Program Revenue 100,000 50,000 Other Tuition Program Revenue-Fall 200,000 50,…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Moshe Yossef I made the all the columns the same but when I append the measure from table 2 is not lining up with table 1...This is how I want it to look Tuition Titles TOTAL_Revenue TOTAL_Aid None…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Moshe Yossef thank you I did that but then it says the format is incorrect because I had to create columns without data in it...I don't know how to correct that...
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
Re: model development
@Mark Oldfield yes so i have data from table 2 with a different measure that i need to append to table 1 that also has a measure...so i am trying to link revenue data to financial data from two…
- Tabitha_DeCaprio
- 1 mth ago
- Questions & Answers
- Reported - view
model development

Hello, I'm developing a model from an oracle connection (two tables). I'm trying to append one of the tables via union however when I do I only get a measure from one table and not the other.…
- Tabitha_DeCaprio
- 1 mth ago
- 19replies
- 53
- Questions & Answers
- Answered
- Answered
Data Model - summarize column, unique row

Hello, I am running into a problem when developing my data model. I have two rows of data: ID AMT CREDITS COUNT_REG UID1 24775 18.00 1.00 UID1 -1286 18.00 1.…
- Tabitha_DeCaprio
- 10 mths ago
- 2replies
- 45
- Questions & Answers
- Answered
- Answered
Re: Case Statement in model
@Alex Scott I've tried: IF( [Term_ID]=[Term_ID], SUM( [AID_TOTAL]), "0" ) and I'm still getting dups.
- Tabitha_DeCaprio
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Case Statement in model
Thank you! Question. Is there a way to create a statement with a sum if or sum attached. I have a table that has for instance an ID with multiple amounts associate with one ID,…
- Tabitha_DeCaprio
- 11 mths ago
- Questions & Answers
- Reported - view
Re: Case Statement in model
@Ian Macdonald Thank you!!!! Big help.
- Tabitha_DeCaprio
- 11 mths ago
- Questions & Answers
- Reported - view
Case Statement in model

Hello! Wondering if someone could help me with a case statement that i have been unsuccessful with and have tried it many ways... Any help would be greatly appreciated.…
- Tabitha_DeCaprio
- 11 mths ago
- 8replies
- 95
- Questions & Answers
- Answered
- Answered

Back to top

Home

View all topics