You’re offline. This is a read only version of the page.
Hi! I want to add a subtraction formula for my column in table A but the other column is in table B [Column 1 (Table A) - Column 2 (Table B)].
Is this possible?
following up on this?
Hi @AhmedSalih here are my tables and the relevant columns. The YEAR MAKE MODEL TRIM column will be the lookup value where for example for a 2022 Chevrolet Silverado 1500 WT vehicle, the Quantity to Buy is = 5, then 2 vehicle purchasers (person A and person B) each were able to buy 1 car of the exact vehicle type (2022 Chevrolet Silverado 1500 WT). The updated quantity to buy should now be 3 given the formula below in Table A.
TABLE A - Vehicles to Purchase
Columns:
TABLE B - Purchase Vehicles
I don't have a Foreign and Primary Key
@Anonymous, can you share your tables schemas? the Columns' names and data samples? Also, do you have a Primary Key and Foreign Key?
@AhmedSalih thank you so much!! one last question, how do I set the look-up column in table B? when I set up the lookup column, it somehow automatically chose a column in table B. I wanted to select another column.
Hello, @Anonymous, yes it is doable if you have a relationship between the two tables. You have to have a Lookup Column in Table A that is linked to Table B. Use a formula that looks something like this:
(TableAvalue-LookUpColumnName.ColumnNameInTableB) << ColumnNameInTableB is where you have your value to subtract.
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
17
Super User 2025 Season 1
Share
Report
All responses (
Answers (
