Formula problem

[cpitc]

I have two fields, Invoice amount and Period which come from our database. periods are from 1 to 12.

I can bring through the field amount and total this no problem. I can use selct expert to use it to just see Period 1. What I need is a way to

Have 1 to 12 totals looking at just the correct period. My plan was to use a formula but I cannot get it to work. I tried Sum with Where which does not work, Any ideas please.

 

[lbass]

If you are trying to do one total per period, then insert a group on period and insert a summary on amount at the group level. If each period is in its own field, please indicate.

-LB

 

[cpitc]

Yes the period as its own field. I have grouped on Period with Summary. What I am trying to get to is to have 12 formulas with the total for each period.

Period 1 Period 2 Period 3

£100 £400 $250 etc....

Any ideas thanks

 

[lbass]

Please see my response to your other thread. You should be using a crosstab for this--assuming that period is one field with twelve instances, not 12 fields.

-LB