aggr?

[n1ef5ng1]

I have this two field, Destination and Arrival.

However, I am using cyclic group to split this two.

is there any way I can create a new field for the total of destination and arrival?

is it by using aggr function to find?

I am unable to use this two field in a table due to complex calculation.

[sujeetsingh]

How you want to combine the two fields ?

What chart you are using ?

Can you please give a sample ?

[#3]

I think you make a new field for the total of destination and arrival

the try this

destination + arrival    as  newfield

[n1ef5ng1]

This is my expression to find Destination,

=if( MonthEnd ( MAX( Date ) ) <> var_EndDate AND MonthEnd( MAX ( Date ) )
= MonthEnd( var_EndDate ) ,

Sum({<
Derived_Status -= {'LRSHP'}
>} TEU / Day( var_EndDate )) * Day(MonthEnd(MAX ( Date )))

,

((sum({$<Derived_Status -= {'LRSHP'}>} TEU) )))

So my expressionshould be

sum( aggr(

if( MonthEnd ( MAX( Date ) ) <> var_EndDate AND MonthEnd( MAX ( Date ) )

= MonthEnd( var_EndDate ) ,  

Sum({<
Derived_Status -= {'LRSHP'}
>} TEU / Day( var_EndDate )) * Day(MonthEnd(MAX ( Date )))

,

((sum({$<Derived_Status -= {'LRSHP'}>} TEU) )))

,Destination ,Arrival)) ?

[n1ef5ng1]

destination and arrival are derived from two different table? how can i combine this two as newfield

[#6]

We couldn't understand your tablestructure and requirement. Could you send samle file?

Karthik