Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Error using Expression.Evaluate & #shared for dynamic query refrence

I have a number of different finiancial queries for each quarter and I want to be able to choose which to pull from dynamically. I attempted to accomplish this like so:   Source = Expression.Eval...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    this call works just fine

    Expression.Evaluate("#""LY-All Branch Summery-Q1""", #shared)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Why, it does indeed!

I was able to use that to make my dynamic names work:

= Expression.Evaluate("#""LY-All Branch Summery-Q" & Quarter & """", #shared)

Thanks AlienSx!