2 Replies Latest reply: Jan 8, 2018 7:11 AM by Sunny Talwar RSS

    How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

    Diwkar Jonnala

      Hi,

      How to concatenate strings for grouped columns and Direct fields in straight table for YTD.

       

      Example Expression that i am using for concatenate is:

      Concat(DISTINCT{<[Financial Year]=,MonthShortName=,FiscalMonthKey={"$(='>=' & $(vSelYrMthStart) & '<=' & $(vSelYrMthEnd1))"}>}Account,',')

       

      Here Account is my grouping column

       

      Please help on the above issue.