Difference between two Sums in related tables where only exists in one
I've got two related tables; ACCOUNTDATA and FINANCIALDATA.
I've got a chart that has dimensions from ACCOUNTDATA .
I've got a sum of ACCOUNTDATA: sum(ACC_AMT_TAX_REP_A_src_2)
I've got a sum of FINANCIALDATA: sum(AMT_TAX_TAXREP_A_src_1) - BUT the chart is set to suppress Nulls so this sum is only the sum where there's a matching record in ACCOUNTDATA (which is exactly what I want).
The challenge is create a Formula ( that I can put in a variable / Text Object ) with the Difference value.
i.e. sum(ACC_AMT_TAX_REP_A_src_2) - sum(AMT_TAX_TAXREP_A_src_1)
BUT only where the AMT_TAX_TAXREP_A_src_1 has a matching record in ACCOUNTDATA. Or in the chart where ACC_GL_ACCOUNT_src_2 is not null.