Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total expression

Hello everyone, how are you?

I want to know, if is possible make an expresison where each row takes its subtotal value.

Example below:

Tables.JPG

    Kind regards, Luiz

1 Solution

Accepted Solutions
sunny_talwar

This should work

(Sum(TOTAL <Category> Distinct {$< Category-={} >} Sales)/1000)

View solution in original post

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this.

Sum(Total <Item> Sales)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sunny_talwar

You mean

Sum(TOTAL <Category> Sales)

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks Sunny.

I always get confused here. But this time I got it.

Will try to be correct next time

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

There is a complication, it has to be a set analysis, I mean, the original sum is a set analysis with some conditions, example:

(Sum( Distinct {$< Category-={} >} Sales)/1000)

sunny_talwar

This should work

(Sum(TOTAL <Category> Distinct {$< Category-={} >} Sales)/1000)

sunny_talwar

I used to get confused in the past, actually I still do....