I am using Data Studio to do a Report on two Data Sources: Income
and Expenses
. These data sources have the same field names and each one of them has a scorecard to sum each of their values in the Amount
field.
I am now trying to create a third Scorecard called Profit
(Income - Expenses) but run into a problem with trying to calculate the Amount Field. When I click on the two Score Cards for Income and Amount then blend the data, I get a defaulted percentage calculation (Income / Expenses):
But when I go to change the operator from /
to -
, it will instead take the difference of the Amount field from the same Data Source and return it as 0.
Is there a way I can figure out the difference between these two same-named fields when referencing two data sources?