Get evaluated formula with concatenation operator

Posted by: asaf.shechter on 21 March 2023, 9:55 am EST

  • Posted 21 March 2023, 9:55 am EST

    Hello,

    I’ve got the following cell formula :

    MEMBER(“PyramidDemo”,“[Manufacturer].[Manufacturer].[”&A2&“]”)

    pay attention we concatenate cell A2 to the formula ,

    the question is there a way to use SpreadJS engine to get the final formula,

    so for example if A2 value is “Acme” I expect to get after formula evaluation :

    MEMBER(“PyramidDemo”,“[Manufacturer].[Manufacturer].[Acme]”).

    Thanks.

  • Posted 22 March 2023, 1:32 pm EST

    Hello,

    We need more information in order to better understand your requirements and use case. Please explain your use case and how the custom function MEMBER works. This will greatly help us to better understand what you are trying to achieve and provide the appropriate solution as per your requirements. You may provide a sample as well which demonstrates what you are trying to achieve.

    regards,

    Avinash

  • Posted 26 March 2023, 11:10 am EST - Updated 26 March 2023, 11:15 am EST

    Hi ,

    we probably found a solution by using the forEachNodes method and then concatinating the values accordingly :

  • Posted 27 March 2023, 6:27 am EST

    Hello,

    We are pleased to know that you have found the solution to the issue you were facing.

    Please let us know if you face any difficulties or need any help regarding this issue. We will make sure to provide you with any necessary assistance.

    regards,

    Avinash

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels