I am using Data Studio to do a Report on two Data Sources:
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
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
-, 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?