LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jolee91

Hi,

I have some data that contains billing values and i need to subtotal the column ...so in excel you would do =sum(A1:A100)

Does anybody know how to do this in lavastorm..i assume you use a Agg Ex node but nothing seems to work

Many Thanks
Jo

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Can you give an example of what you have has a data set and what you want the output to look like? Seen this done many ways

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jolee91

Originally posted by: xathras
					

Can you give an example of what you have has a data set and what you want the output to look like? Seen this done many ways
			

Hi - thanks for the reply. So i have a file with various columns in such as billing address etc etc and then bill value by phone number eg 23.99.
so i want my data to appear
23.99
6.99
2.30
1.50
6.40
41.18

hope this makes sense!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Yes, you will need to use an Agg node, but there are a few tricks to get the output in the format you desire.

Tricks...

First in the Agg node you will use a constant value in the GroupBy parameter. I used the value "1". This will force the node to output only 1 record, which is your Total Bill Value record.

Since all of the values and total will be in the same column, name the column something generic like "Value".

In order to distinguish between the Bill Value records and the Total Bill Value record you can add a new field called "Description" so you always know which record is the Total.

Make sure that your data and that Agg output have the same field names and use a Cat node to add the total record to the data.


See Attachment for Example...
Attachments:
SumBillValue.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jolee91

Thank you for this.

My version doesnt seem to recognise the groupSum in the agg node. do you know of any alternative? sorry to be a pain!

Thanks you so much for your help!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Try the function sum() instead of groupSum(). The groupSum() function was created in LAE 4.6.0 and the function sum() was deprecated. If you are using an LAE version prior to 4.6.0 that is why it would not work.

Thanks,
Larry