AnsweredAssumed Answered

Report calculations....

Question asked by JodieWeston on Mar 20, 2018
Latest reply on Mar 22, 2018 by JodieWeston

Help, please!!!

 

Shot Table:

Sequence Code

First Scene in Act

Shot count

Act

Shot number

 

Sequence Table:

Sequence Code

Sequence Budget

Sequence ETC

 

Report (see attached):

Part setup -

Top

Header

Sub-summary when sorted by 'Episode'

Sub-summary when sorted by 'Act'

Sub-summary when sorted by 'First scene in Act'

 

Report requirements:
There are Sequences that go across multiple Acts. I need to split the total Budget or the Sequence up, so it only displays the costs relevant to the relevant Act.

 

See example attached (Report_example.pdf):

As you can see, Happy is in both Act 2, and 3 (total $11,259). I would like the costs to be split like this:

Act 2, 9 shots = $7,794.69

Act 3, 4 shots = $3,464.31

 

I'm at a total loss.

 

Thanks,

Jodie

Attachments

Outcomes