problem

[#1]

how to calculate the max of this kind of number

[its_anandrjs]

Hi,

Did you try

=Max(COEP_Key)

Regards

Anand

[anbu1984]

You can try MaxString()

[Gysbert_Wassenaar]

Those are text values. You can try using the maxstring function: maxstring(COEP_Key). But if those values should be numbers then use the num# value in the script to cast the text values to numeric values: num#(COE_Key) as COE_Key

[its_anandrjs]

You can try some of this

=Max( Num(COEP_Key) )
Or
=Max( Num#(COEP_Key) )
Or
=Maxstring( Text (COEP_Key) )
Or
=Maxstring( COEP_Key )

Regards

Anand

[#6]

I already applied num# ,but the number remain in string  format,

This is the field of COEP table of SAP ,i have to apply increamental load on the  basis of primary ,for that i need coep_key

[tyagishaila]

You can use Statistics Box for the field, for which you want to find max value.

[#8]

if i do that this single table more than 2 hrs to relaod

[#9]

Hey Anand,

Maxstring asd Maxstring text functional ,but is it a good practice to use maxstring functional while implementing incremental load in order to find new records.

[#10]

i want to implement it in backend