Hi,
I have two forms in AppSheet which are managed by two teams, sales and accounts. I want to connect these forms’.I have the sum column in sales and accounts. I want a separate view difference between the sum values (sales sum - accounts sum). how can I do that and where I can show the result (UX)
I’m not sure if this could help but:
Perhaps create a VC in one table using something similar to this:
(
SUM(
SELECT(SALES TABLE[SALES SUM],
ISNOTBLANK([SALES SUM])))
-
SUM(
SELECT(ACCOUNTS TABLE[ACCOUNTS SUM],
ISNOTBLANK([ACCOUNTS SUM])))
)
Create another view for the table with the VC and only display the VC within the view.
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |