having issue with summary calc

[solarpunk]

Hello,

i was wondering if someone can help me out with this. Basically i have a summary report base on the field call status. The status field is drown down menu.

I have one calc that is not working me. This how i have it,

i have the fields:

c_Withdrawn Calculation = Status="Withdrawn"

c_cnt_Withdrawn Summary = Total of c_Withdrawn

c_c_cnt_Withdrawn Calculation Unstored, = Sum(c_cnt_Withdrawn)

The calculation works as long I change the Status name to Something else.

any help would be appreciate it.

[Brian C]

You need to add one more field to this so that it can add numeric values.

Create a calculation field: c_StatusWithdrawn = if(c_Withdrawn = "Withdrawn" , "1" , "0")

Then base your summary fields on this field instead so that any record marked as Withdrawn will have a 1 displayed and thus added to a total.

[solarpunk]

Brian,

I try it the way you say and it doesnt work. The crazy part is that i i used a different status and it work fine.

is Withdrawn a FM Reserve word?. i am using FM 6.0 by the way.

thanks for you help. i thnking of rename the status to WD-Withdrawn since that work for me.

thanks

victor

[comment]

c_StatusWithdrawn = if(c_Withdrawn = "Withdrawn" , "1" , "0")

There is no need for that. The existing calculation field:

c_Withdrawn = Status="Withdrawn"

already provides the same result: 1 if Status = "Withdrawn", 0 otherwise.

Victor,

I cannot see any problems with the names, either. The only thing I don't understand is:

c_c_cnt_Withdrawn Calculation Unstored, = Sum(c_cnt_Withdrawn)

What is summing a summary field supposed to accomplish?

[solarpunk]

Comment,

I used that field to the sum of all withdrawns and display it in sub-summary report i create. I include screen shot of my report.

I just end up rename the status field and it is work fine now.

Thanks all for the help. i really appreciate it.

thanks

victor