Graph Expression Query

[anthony_kinsell]

Hi,

I'm trying to show the accumulation of a cost split between 2 accounts that it will be taken from. Attached is my output.

My formula is simple Sum([Cost Draw Down]) & I have ticked the 'Full Accumulation' box on the expression tab

What I need it to do is to continue showing the €2,000,000 for the Equity account in the periods 30/04/15 - 31/10/15.

Anybody any ideas?

[anthony_kinsell]

Sorry I meant to say that I think I need to do some type of aggregation?

[vishsaggi]

Hi Anthony,

Is it possible to share a sample .qvw file you have been trying.

Tks,

V.

[anthony_kinsell]

No not really - too much sensitive info.

Basically I have a [Cost Draw Down] for the WC a/c & a [Cost Draw Down] for the Equity a/c.

The formula Sum([Cost Draw Down]) is giving me the correct totals for each a/c but I need the total [Cost Draw Down] split by account.

[anthony_kinsell · Accepted solution]

Thanks for looking & any attempts at helping.

I worked out the answer.

Just needed to put in separate formula for each source:

Sum(If([Loan Name] = 'Equity Account', [Cost Draw Down]))

& remove the loan name as a dimension.