Multiple campaigns and custom formula for each campaign in one table
is it possible to have a table which would be used to calculate adwords budget difference (actual vs planned) for three campaigns in one table? Structure:
column(1): Campaign as dimension - in overall there is 3 campaigns;
- campaign 1 planned budget: 300 dollars;
- campaign 2 planned budget: 200 dollars;
- campaign 3 planned budget 80 dollars;
column(2): cost on each campaign - exported via data studio/adwords sync;
column (3): campaign budget - cost
I can do one condition on one campaign by adding formula: 300 - cost, but how to do a formula, which could calculate difference in every row, depending on campaign planned budget? Is it with case statement?
Could someone help me out?