Calculating Total Sum between two fields in reporting

[sam222]

Hi all - 

I am running a report on a scoped app table. 

There are two fields 'Fee type 1' and 'Fee type 2' both contains $$.

I need to run a single score report or another report type where the total sum between the two fields are calculated and shown in the report (not in a form or record, but in the report).

For example: Total Fee = 'Fee type 1' + 'Fee type 2'

I have tried the sum aggregation, but it only sums up the single column, and I am unsure of a way to calculate a total sum between two columns through reporting (without creating another total sum field, which I prefer to avoid).

I am not that familiar with advanced reporting or scripting, so if there is a solution, please advise. Appreciate your help in advance. Thank you!

[Ankur Bawiskar]

@sam222 

Did you try to explore function field in reporting?

[sam222]

Thank you Ankur, this was very helpful. 

I was able to accomplish the initial challenge of calculating the total from the two fields. However, I was wondering if its possible to add "$" character in the beginning of the total sum value?

[AndersBGS]

Hi @sam222 ,

As  @Ankur Bawiskar  already have metioned, function fields in the report designer will be able to help with your question.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AndersBGS]

Hi @sam222 

If my answer has helped with your question, please mark my answer as accepted solution.

Best regards

Anders