This content has been marked as final.
Show 4 replies
-
Return Last String in field - using expression
Aldea Cosmin Mar 18, 2011 10:01 AM (in response to Neil Henderson)Hi, try this one:
=FieldValue('Cost',FieldValueCount('Cost'))
it is really important that you use single quotations. i've tested it on a text object expression
-
Return Last String in field - using expression
Neil Henderson Mar 18, 2011 10:09 AM (in response to Aldea Cosmin )Apologies. that was unclear, your response works to a certain extent.
i am looking to group rows of data with the same reference ( see below )
Ref Cost
1 100
1 200
1 170
2 150
2 160
2 200
Would return
1 170
2 200
-
Return Last String in field - using expression
Sandro Pividori Mar 18, 2011 10:27 AM (in response to Neil Henderson)Hi!
See the example.
Regards.
-
ultReg.qvw 118.0 K
-
-
Return Last String in field - using expression
Benjamin Agger Mar 18, 2011 10:32 AM (in response to Neil Henderson)Hello MITeamEldon,
I'm not quite certain if you want it in the script or in a sheetobject.
But here is my suggestion for a script://testdata:
tbl:
LOAD * INLINE [
Ref, Cost
1, 100
1, 200
1, 170
2, 150
2, 160
2, 200
];//now load the data again,
//and find the last value of Cost per Ref
tblsum:
load
Ref,
LastValue(Cost)
resident tbl
group by Ref;drop table tbl;
Best regards
-
-