Function inside Identifier RRS feed

  • Question

  • Hi,

    I created an column using the following name:

    Year_int = 2017,

    {Number.ToText(Year_int+0,"D","")&"/"& Number.ToText(Year_int+1,"D","") &" Non-sal"}

    which creates [#"2017/2018 Non-sal"] 

    I am trying to make a column that adds [#"2017/2018 Non-sal"]  + [#"2018/2019 Non-sal"]  together

    But uses the dynamic formula such as: (this is what i m trying to do

    [#Number.ToText(Year_int+0,"D","")&"/"& Number.ToText(Year_int+1,"D","") &" Non-sal"] + [#Number.ToText(Year_int+1,"D","")&"/"& Number.ToText(Year_int+2,"D","") &" Non-sal"]

    Is there anyway of doing this correctly?

    Tuesday, July 17, 2018 3:52 PM