Forum Discussion

JeremiahMason's avatar
JeremiahMason
Advocate I
5 years ago
Solved

Population Mix Adjustment

I have population-adjusted costs from CY18 to CY19 and my goal is to use the CY19 population distribution on the CY18 data to put them on an apples-to-apples basis. I.e. I have per-person costs for e...
Need Help
  • JeremiahMason's avatar
    JeremiahMason
    5 years ago

    I got it figured out - you can, in fact, do what I was trying to do by defining an inactive relationship holding the CY portion of the calculation constant and use the UseRelationship function to force the measure to use the inactive relationship. My issue was caused by my key field used in the relationship having an error.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey JeremiahMason ,

 

your explanation is understandable but a little abstract.

Maybe you can post the tables and data model and give an example how the result should look like. This makes it easier to help. Best case would be if you could share the file if the content is open to share.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
JeremiahMason's avatar
JeremiahMason
Advocate I
5 years ago

I got it figured out - you can, in fact, do what I was trying to do by defining an inactive relationship holding the CY portion of the calculation constant and use the UseRelationship function to force the measure to use the inactive relationship. My issue was caused by my key field used in the relationship having an error.