Difference calculation

[Anchor_Appadmin]

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)

[Chris_Jeal]

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.