Describe the set up of the Sub total layout part where you are getting the incorrect values. What kind of fields are producing the 5, 10 , 20 instead of 15, 30, 40 values? Are they summary fields?
Hi Phil - Thanks for your response.
The fields i have in my body section are calculated fields. For e.g. For "Jan Revenue", the calcualtion is something like (If Month = "Jan";RevenueAmount;0). Where Month = Month name as stored in my Revenue Table and RevenueAmount is the revenue amount stored per project, month and year.
At first, i copied this same field into the Sub Summary regions and it did not work. Next, i went back into the DB Setup and created Summary Fields that Total the amounts. So, in the above case, i created a new summary field called "Jan Revenue Sum", which is a total of the calculated field "Jan Revenue". I then copied this field into the sub summary, but the result is the same and where i get the 5,10,20 instead of 15,30,40
Awesome! :) My first week with FM and i run into this...
I went through that post, so it would seem that at some point, my totals should at least work i.e. if i do not re-sort when displaying or if i use a particular sort order. I will play around with the sorting order or something to see which works. Besides that, Is there another approach i can try?
Thanks again for looking into this.