Hi @paula012 Try using the Previous function. The logic would be to verify the previous record field value and the current recorded field value and make it ‘’(empty string).

Hope this helps.

Thanks

Thanks but sorry, I’m really new into using this. Where’s that previous function and where do I state the ‘empry string’? Thanks a lot @ChandrasekharM !

Hi @paula012 Please check the steps in the below screenshot and the expression as an example.

Hi @paula012! Have you considered moving this field into a grouping section? For issues with duplicating data like names, items, or locations then it can be easy to group by the name field and then you’ll only see one.

This can be an issue though if you are also showing amounts or any number values which populate alongside the names because then these will become grouped and SUM will be applied to the grouping, causing the numbers to be overstated.

If no number values are to be used then grouping will be your quickest and easiest option