Forum Discussion
Linking Dates Between 2 Tables
OK, that's the problem then. You want to relate your tables and then in your NPV calculation, override the context by using an ALL or ALLEXCEPT. You can always override context from a relationship, but you can't invent a relationship where none exists.
Are you two tables related to one another?
Greg_Deckler Hi Greg, they are not. Reason for this was for the purpose of creating a trailing 12 month formula (NPS retention above). I have the formula and numbers the way I'd like to currently, and when I try to relate the 2 tables via their dates it changes the results of my NPS retention formula and I'm not sure why.
OK, that's the problem then. You want to relate your tables and then in your NPV calculation, override the context by using an ALL or ALLEXCEPT. You can always override context from a relationship, but you can't invent a relationship where none exists.