Select all

[n1ef5ng1]

Hi all,

I have this particular table where it will show the value if the 'Box' have dwell value in it.

I need to select ALL in this particular field call 'Tranship_Dwell' to give me the correct value in the table.

Is there any code that I can use to replace the current solution where user have to select ALL on the tranship_dwell field?

I tried if(Tranship_Dwell <> null(), sum(Expression))

i also tried if(Tranship_Dwell >= 0, sum(expression)

both gave me - value

[#2]

Hi,

     If am not mistaken you would like to sum the value of the whole Tranship_Dwell dimension. If that is the case, I would suggest you create a Straight Table Chart, and in the Expression column add in an expression of Sum([Tranship_Dwell]).

     By doing this, you wouldn't have to highlight the whole Tranship_Dwell dimension to produce the sum of the whole dimension. It will auto compute and show you the sum.

Hope this helps!

Best Regards,

Ram

[n1ef5ng1]

no is not, tranship_dwell is a condition whereby if it fulfills, it will therefore do an expression which is abit complex.

is not about summing up the total value of the tranship_dwell

[MayilVahanan · Accepted solution]

Hi

This can be achieved by

=sum({$<Tranship_Dwell = {'*'} >} Sales)

here {*} selects all values

or

= Sum(total Tranship_Dwell)

hope it helps