Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to calculate the max of this kind of number
Hi,
Did you try
=Max(COEP_Key)
Regards
Anand
You can try MaxString()
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
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
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
You can use Statistics Box for the field, for which you want to find max value.
if i do that this single table more than 2 hrs to relaod
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.
i want to implement it in backend