Only total in straight table in Column

[bsbernabe]

Hi There,

There's any possible way that i can view only the total of Straight table in a simple way?

this is what i have:

this is what output that i need.

Regards Bing

[ahaahaaha]

Which fields should be in dimensions and expressions of the table?

Regards,

Andrey

[sunny_talwar]

Is this what you want?

Used this expression:

=If(Dimensionality() = 0, Sum(WRKSum), ' ')

[bsbernabe]

Hello Sunny Thank you for your support, base on your expression what i need is the Total of Rows i do something but i know its not proper or correct cause I'm using Distinct to get the Total Row can you correct me

=Sum( aggr( sUM(Distinct If(DIVISIONCODE= 'HO', NetWorkDays(SUSDATEFR1,SUSDATETO1))),BADGENO,PENALTY) ) +

    Sum( aggr( sUM(Distinct If(DIVISIONCODE= 'HO', NetWorkDays(SUSDATEFR2,SUSDATETO2))),BADGENO,PENALTY) )

Note Try to Use sample

0369 i got the correct Total but here at

0811 i got wrong Total

Best Regards,

Bing

[sunny_talwar · Accepted solution]

Try this:

=Sum(Aggr(Sum(Distinct {<DIVISIONCODE = {'HO'}>} RangeSum(NetWorkDays(SUSDATEFR1,SUSDATETO1), NetWorkDays(SUSDATEFR2,SUSDATETO2))), BADGENO,SUSDATEFR1, SUSDATEFR2, SUSDATETO1, SUSDATETO2))

[bsbernabe]

Yes. Thank you Sunny I got it you such a great..