I created this formula but i can not figure out what is wrong as I keep getting an error when i verify it....
my formula: substring(eval(eval(IDQ |Hub | ETL | DAL |RTI |ImpactToBudget |ImpactToTimeline)[. !=""], 'concat(", ", .)'), ".."),3)
I get this error:
Expected value type: end-of-string
Actual value: ,
substring(eval(eval(my:ImpactAnalysis/my:IDQ|my:ImpactAnalysis/my:Hub|my:ImpactAnalysis/my:ETL|my:ImpactAnalysis/my:DAL|my:ImpactAnalysis/my:RTI|my:ImpactAnalysis/my:ImpactToBudget|my:ImpactAnalysis/my:ImpactToTimeline)[. !=""], 'concat(", ", .)'), "..")-->,<--3)
any help would be appreciated. Thank you