We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

How to sum a column and Add total at the bottom of the column?

SanaUlBari
6 - Meteoroid

Hi All

 

I am trying to sum and add the sum total at the bottom of the column. For Sum i am using summarize function but how to add that sum as 'closing' balance in the below table?

 

SanaUlBari_0-1673520609994.png

 

Thanks

Sana

 

15 REPLIES 15
ShankerV
13 - Pulsar

Hi @SanaUlBari 

 

Step 7: Formula tool

ShankerV_0-1673524210869.png

 

ShankerV_1-1673524220789.png

 

Step 8:

ShankerV_2-1673524240201.pngShankerV_3-1673524254306.png

 

 

Output post Run:

 

ShankerV_4-1673524279690.png

 

Many thanks

Shanker V

ShankerV
13 - Pulsar

Hi @SanaUlBari 

 

Few information,

 

1. The below tool is Dynamic Rename tool.

ShankerV_0-1673524431554.png

It can be found in the Developer as highlighted below.

ShankerV_1-1673524473422.png

 

2. The workflow will work dynamically even if you have more new months added.

Input

ShankerV_2-1673524569254.png

 

Output

ShankerV_3-1673524596525.png

 

3. If the input contains - in the input, you need to use Select tool to change the datatype.

ShankerV_4-1673525396818.png

 

ShankerV_5-1673525468497.png

 

ShankerV_6-1673525503561.png

 

Many thanks

Shanker V

 

SanaUlBari
6 - Meteoroid

Hi James

 

Thanks for suggesting CReW macro, when i am using it its totalling current month correctly in the correct column and for other 11 months, its showing totals in separate column. What am i doing wrong here?

 

SanaUlBari_0-1673527946967.png

 

Thanks

Sana

ShankerV
13 - Pulsar

Hi @SanaUlBari 

 

As per the screenshot attached, it is not matched and reflecting in the new column because of the column name mismatch.

 

2022-08-31 is not equal to 2022_08_31

 

ShankerV_0-1673528423168.png

 

Many thanks

Shanker V

 

ShankerV
13 - Pulsar

Hi @SanaUlBari 

 

The column name 2022-08-31 (from input) is not equal to 2022_08_31 generated by CREW macro.

 

As I have restrictions to download here, I can't download the CREW macro now. 

Or the output column name can be amended with Dynamic rename tool inside the macro.


To overcome this issue,

Modify the columns names from with the help of Dynamic Rename tool before the CREW macros so it will
rename the column names as  2022_08_31 which will match the CREW macro output too.

 

This will help to overcome the issue.

 

Note: Use Dynamic Rename tool to rename the column names.

ShankerV_1-1673529480799.png

 

 

Many thanks

Shanker V

JamesCharnley
12 - Quasar

Hi @SanaUlBari 

 

Shanker is right. It's a limitation in how columns need to be named. The fields can't contain special characters or it won't work so you'll need to rename them before and, then again afterwards to reverse it if you wanted.

 

JamesCharnley_1-1673532137696.png

 

Labels