Just thinking out loud, because I don't have an universal connector to test with.
What if you use NL("Filter") to retrieve the values you need.
Use the outcome of that function with NP("Join") and as a seperator you use the "+".
That will create a string with values and a plus between them.
To evaluate that string you need to define a name with the formula EVALUATE(). Unfortunately that function doesn't work directly in a cell. Don't ask me why :)
That name will do the calculation of the values in the string and can be used in excel formulas.
D7=NL("Filter","Table","Numeric field disguised as text","Filterfield1","Filter1")
D8=NP("Join",D7,"+")
Create a name within Excel with the formula =EVALUATE($D$8), call it e.g. SummedText
D9=SummedText
HTH
rmw
Date
Votes
3 comments
-
Jet Reports Historic Posts I am using a universal connector to report off of a database that has certain custom text fields. Our software provider chose to run numeric information into that field but leave it as a text-type instead of a number-type field. Is there a way to use Jet to sum the numbers in that text field without pulling them into excel individually (using a Jet function), converting the text to numbers in excel, and summing the numbers in excel as normal?
Hopefully that's enough information to explain what I'm trying to do, if not I'm happy to try and elaborate.
Thanks. -
Jet Reports Historic Posts Hi,
good question :?
I don't see a Workaround that will work.
But if you find one, please let us know
regards -
Jet Reports Historic Posts seems simpler to do your originally suggested method. probably faster than NL(SUM) too :)
Please sign in to leave a comment.