Forum Discussion

danb's avatar
danb
Resolver I
6 years ago
Solved

Taking Difference between two columns in a Table Visual (Values from different tables)

Good Morning! I feel a bit foolish having to ask this question however I am stumped. I have a table visual that I am trying to layer out a budget and then the actual amount spent per account # per p...
Need Help
  • danb's avatar
    danb
    6 years ago

    Icey  - thank you for your response. You are spot on and the issue is being caused by the relationship (or lack thereof). I actually went down the path of merging the two tables together into a new table and solved the issue that way. 

     

    Dan

Icey's avatar
Icey
Community Support
6 years ago

Hi danb ,

I make a sample. If your data structure is similar to mineļ¼Œthe measure you create is meaningless. Because the value of 'Budget Amount' is the whole 'Fiscal Period' and the value of 'Actual Spent' is the specific value of each 'Account Description'. They are not one-to-one correspondence in the Table visual. Then you can tell me what do you want to do, so that I can help you better.

Best Regards,

Icey Zhang

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • danb's avatar
    danb
    Resolver I
    6 years ago

    Icey  - thank you for your response. You are spot on and the issue is being caused by the relationship (or lack thereof). I actually went down the path of merging the two tables together into a new table and solved the issue that way. 

     

    Dan