JulianJohnson

Simple(?) calculation query

Discussion created by JulianJohnson on Dec 13, 2016
Latest reply on Dec 13, 2016 by David Moyer

Hi All,

 

I need to do what I'm sure should be a really straightforward calculation and am having a total brain freeze.

 

I need to return a carriage delimited list with the same number of lines as I have related records.

 

So I have a calculated field in my parent table and just say there are three related records in a child table, I just need to return the value of a different field in the parent table three times on separate lines as my result.

 

I have the List() function, I was hoping I could do with Substitute but don't have a reliable field value to substitute from (unless I just put in a calc always returning the same value). I'm sure there's a way more elegant way to do it!

 

I'm so sure it's simple but I'm having a complete blank!

 

Thanks in advance.

 

Kind Regards

Jules

Outcomes