Hi All,
Trying to add one list of code into a function dynamically. But it seems not doable in "Formula" function.
Not sure what tool/function i should use for this.
Additionally, not sure whether it is possible to add fixed string in there,(i.e.: "/*/")
Many thx
Input
Member |
ABC |
DEF |
GHI |
Desired Output
Formula |
=Test_ABC("ABC","","/*/","/*Rank*/") |
=Test_ABC("DEF","",,"/*/","/*Rank*/") |
=Test_ABC("GHI","","/*/","/*Rank*/") |
Solved! Go to Solution.
Use this:
'=Test_ABC(' + ToString([Member]) + ',"","/*Rank*/")'
appreciated @caltang