Problem with Summary Field

[NaderNouri]

Hello Guys,

I have a problem with setting the summary report. I attach a sample file which contains a report using summary field. The problem is I can't multiply a summary field's value to another field's value and get a correct result.

Any help would be appreciated in advance.

Kind regards

Product.fp7.zip

[comment]

Try it this way, perhaps?

Product2.zip

[NaderNouri]

Try it this way, perhaps?

Thanks a lot. It works perfectly for me.

But I still have this question "can we use a summary field in our calculation?"

[comment]

Yes, you can - but is more complicated in this case. First, you must use the GetSummary() function for the sub-summary results. For this, the breakfield cannot be a related field; you must sort and sub-summarize by the "local" ProductID field. You also cannot total the results of the calculation, because it returns a result for every record.

[NaderNouri]

Yes, you can - but is more complicated in this case. First, you must use the GetSummary() function for the sub-summary results. For this, the breakfield cannot be a related field; you must sort and sub-summarize by the "local" ProductID field. You also cannot total the results of the calculation, because it returns a result for every record.

as you said it is getting more complicate for me.

thanks a lot for your help