5 Replies Latest reply on Jan 3, 2017 7:51 AM by Norbert Maijoor

# Plot of 3 Types of Revenue against 3 other types of revenue

I

1) Background

My data looks like this: 2) Eventual Goal

I want to be able to plot the combination of 3 revenue source against 3 other revenue sources

3) Initial Step. Calculating a calculated field for "04 Earned Fees" and the displaying Earned Fees per school with this calculated field

I'm trying to create a calculate field that provides earned fees for each school (sample correct data is highlighted yellow). I wrote this expression and the syntax is correct but nothing is returned.:

if attr([Act Header])= "04 Earned Fees" then sum([Amount]) end

and this also fails to return anything

if attr([Act Type])= "Revenue" then sum([Amount]) end 4) Curiosity #1.

If I place ActHeader on the detail tab, it does display some values 5) Curiosity 2. If I adjust the field as follows, it does return values (without the ActHeader)

if attr([Number])= 1 then sum([Amount]) end

if attr([School Type])= "ES" then sum([Amount]) end

Thanks for any insights!

Josh

• ###### 1. Re: Plot of 3 Types of Revenue against 3 other types of revenue

Hi Josh,

Find my approach below as reference and stored in attached workbook version 9.3

RevA: if [ActType]="A" then [Amount] END for each ActType A,B,C,X,Y,Z

[RevA]+[RevB]+[RevC]: sum([RevA])+sum([RevB])+sum([RevC])

[RevX]+[RevY]+[RevZ]: sum([RevX])+sum([RevY])+sum([RevZ]) 1 of 1 people found this helpful
• ###### 2. Re: Plot of 3 Types of Revenue against 3 other types of revenue

Thanks so much, Norbert. You're a hero!

• ###### 3. Re: Plot of 3 Types of Revenue against 3 other types of revenue

Hi Josh,

Glad I could help out. Thanks for the "Awards". Much appreciated!

Have a nice one!:)

• ###### 4. Re: Plot of 3 Types of Revenue against 3 other types of revenue

Hey Norbert -

Can I ask a quick follow-on question? Maybe it's better to add a new question.

The method that you offered is dead simple and easy to implement. So thanks again! Is there another method that scales better? For all ten calcs I've made, I end up making about 5 variables for each. So it explodes to 60 total calculated fields.