Get the cell value data to based on dimension

143kishornaidu
143kishornaidu
edited July 24 in Modeling
Screenshot 2024-07-24 203059.png

Here in the same module . where line item having no's. Other line item is input. if the no is same then then first input value should should return

Thanks

Answers

  • jagadishdash
    jagadishdash

    @143kishornaidu You can achieve this by isfirstoccurrence formula; Find the isnotblank of Input then do the first occurrence of Line item. Then firstoccurrence will be boolean then by that boolean you can bring the text cf.

    Hope that helps

  • 143kishornaidu
    143kishornaidu
    edited July 29

    can u give a example

  • jagadishdash
    jagadishdash

    @143kishornaidu

    If I'm understanding your requirement correctly, Then Here is the below screenshot;

    image.png
    image.png

    If it is not the case let me know the correct details of columns?

    Thanks,

Categories