Forum Discussion

I_Like_Pi's avatar
I_Like_Pi
Icon for Resolver II rankResolver II
10 years ago
Solved

Creating a measure from value on multiple related Tables (NEWB)

I have 1 flat transaction data source that I have created 2 tables from. 1 is pretty much a straight dump of the data, and the other is built using the summarize command to get the Stats of the Store...
Need Help
  • jahida's avatar
    jahida
    10 years ago

    I definitely don't think you need to do anything in Edit Queries (no need for a merge), but I do agree that making this as a calculated column in the Transaction table is your best bet. Note you'll need to add a RELATED() around any reference to a column in the other table.

jahida's avatar
jahida
Icon for Impactful Individual rankImpactful Individual
10 years ago

I definitely don't think you need to do anything in Edit Queries (no need for a merge), but I do agree that making this as a calculated column in the Transaction table is your best bet. Note you'll need to add a RELATED() around any reference to a column in the other table.

I_Like_Pi's avatar
I_Like_Pi
Icon for Resolver II rankResolver II
10 years ago

KABOOM

You are a rockstar jahida!!

Thanks,

I'm such a NEWB

 

I could not figure out why it would not accept a column from another table in the calc.

  • jahida's avatar
    jahida
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    Haha thanks, yeah the related function is a bit to get your head around (doesn't feel like it should be necessary but is).