Hi Sven, thank you for the advice! I did need to iterate to pick up all last notes on all children of the task. This is the code that worked for me: displayname=Last Notelistdelimiter=<p>listmethod=nested(children).liststextmode=truetype=iteratevalueexpression=IF(ISBLANK({lastNote}.{noteText}),"",CO...

Hi @Heather_Kulbacki thank you for the steer. By looking at collections I realised I was referencing the wrong collection - it needed to be children, NOT tasks. 

Hi @Sven-atClient Thank you for your advice.Can you further explain your comment "A parent tasks' parent would display duplicates, too."?You are correct the lastNote doesn't display all notes. Thank you as that clarifies things for me - I am actually looking to list all  last notes on any child task...

Hi,I am trying to generate a custom column in a view in a report which lists all the notes sitting under a parent task, but this is pulling nothing.Is there a way to do this?displayname=Last Notelistdelimiter=<br>listmethod=nested(tasks).liststextmode=truetype=iteratevalueexpression=IF(ISBLANK({last...

Thank you Skye! Worked a treat. Well that was ChatGPT sending me on a wild goose chase.The complete code for anyone interested is: displayname=Y1 Profit Totaltextmode=truevalueexpression=(SUM({DE:field1},{DE:field2},{DE:field3}))valueformat=currencyString

I am trying to create a calculated column in a task report that sums a number of calculated fields.The fields are in Currency format and some may contain null values. I have tried the following code with no result:displayname=Y1 Profit Totaltextmode=truevalueexpression=(IF(ISBLANK({DE:PD - AA EA Y1 ...