Need some help with formula

Szarek
Occasional Contributor

Need some help with formula

Hello, 

I am Sylvain. I work in a french confectionnery. Not the unicorn candy company 🙂

 

I am building a cash flow monitoring and I have to import the bank book in a data module :

Only one line item is list formated : "compte" 

Other are text, number or date

Sans titre.png

And the trouble is about the date. i have to take the data from the row "'dat.point".

But i only have the date on 1line by accounting entry (row "piece")

How can i complete the empty cell with the date? The date is always on the last line, like on the screenshot.

 

i was thinking about making a list with "Piece" but it's maybe overkill

or maybe using ISFIRSTOCCURRENCE ?

thx a lot!

Sylvain

 

1 ACCEPTED SOLUTION

Accepted Solutions
Szarek
Occasional Contributor

So the list is the way to go.

Thx a lot for the quick answer @Akhtar.shahbaz and @Misbah 

have a nice day

Sylvain

 

 

View solution in original post

3 REPLIES 3
Misbah
Moderator

@Szarek 

 

I think creating a list and storing dates against list items should be the way to go. And then use LOOKUP to retrieve the dates into the module

 

Misbah

Akhtar.shahbaz
Community Boss

Hi @Szarek ,

 

I am assuming that you have stored data in a flat list.

Step 1: Create the piece list 

Step 2: Create another system module to store the data by piece via action, you can apply filter line item as a filter in your view.

Step 3. write a formula to lookup the value from sys module to the main module via lookup.

Screenshot_256.png

Screenshot_257.pngScreenshot_258.png

 

Screenshot_259.png

Screenshot_260.png

 

Hope this helps

Thanks

Akhtar

 

 

 

Szarek
Occasional Contributor

So the list is the way to go.

Thx a lot for the quick answer @Akhtar.shahbaz and @Misbah 

have a nice day

Sylvain