Subtotal row and weighted average

Aspose.Cells Product Family
1

Hi,

is it possible to calculate weighted average on sub total row between two columns? I am using templates with smart markers. I know how to write it in excel formula (=SUMPRODUCT(A3:A3;C3:C3)/SUM(A3:A3)) but problem is how to write it as dynamic smart marker.

-Aki

2

Hi,

Thanks for your posting and using Aspose.Cells.

Please provide us your template file with smart markers and the expected output file which you are trying to achieve with it.

You can create both of them using Ms-Excel 2010 and post it here.

We will look into your issue and help or advise you asap.

3

Hi,

ok, here is simplified files for you to look in. Data.xls is datasource for template.xls with smart markers and result.xls is expected output. Template.xls cell D3 is where I want weighted value for each group.

Thank you.

-Aki

4

Hi,

Thanks for providing us the needed files and using Aspose.Cells.

We will look into this issue and provide you a sample code or workaround how to achieve your desired results.

We have logged this issue in our database with the issue id: CELLSNET-41180

Once, there is some update for you, we will let you know asap.

5

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

After looking into this issue, we think we should add a new Smart Marker to support your need.

The smart marker is same as &=subtotal0:Data.SubGroup&formula=SUMPRODUCT({C},{D})/SUM({C})

We will process {C},{D} as a range in processing subtotal smart marker.

Could it fit your needs? Let us know your feedback.

6

Hi,

that looks just what we need for, great! This kind of calculations are common to us and your proposal would help a lot. Thank you!

7

Hi,

Thanks for your input and using Aspose.Cells.

We will provide you a fix that could fulfill your needs. We have logged your comments against the issue id: CELLSNET-41180.

Once, there is some update for you, we will let you know asap.


8

Hi,

Thanks for using Aspose.Cells.

We have supported this feature in new fix 7.3.3.4.

Please check the attached template file.

Please download and try this fix: Aspose.Cells for .NET v7.3.3.4 and let us know your feedback.

9

Hi,

with quick testing this fix seems to be working and solves our problems. Excellent service you have, thank you very much!

-Aki

10

Hi,

Thanks for your comments/feedback.

It’s good to know your issue is resolved now with the latest fix.

Please feel free to post if you find any other issue. We will be glad to help you further.

11

The issues you have found earlier (filed as CELLSNET-41180) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.