Cannot Lookup nor Firstnonblank, how can I solve this?

LucaRicci
LucaRicci
in Modeling

Hi All,

I have been trying to come up with a solution to this problem;

I need to let the "belong to fab category?" boolean be checked whenever a cost element list item belong to that particular fab category (e.g. "direct labor")

image.png
image.png

Now, the user has been already giving me this information in another module:

image.png
image.png

However, the list of this module is different from mine, featuring a combination of cost center and cost element. As you can see though, the cost element (as I have it in the first module) appears in the last column.

I was wondering if there was a way to pull out the Fab Category from this last module and push it into the first one, because there seem to be all the informaiton I need but apparently no lookup and not even firstnonblank formula can help, as far as I know (given that the same cost element can be matched to multiple cost centers and multiple fab categories).

Many thanks,

Luca

Tagged:

Answers

  • Dikshant
    Dikshant

    Can you please put together in Excel and share the source and target modules and it's dimensions for better understanding.

  • LucaRicci
    LucaRicci

    @Dikshant Hope it's clearer now:

    SOURCE MODULE

    rows: cost center | cost element list

    columns: FAB Category, Cost Center, Cost Element line items

    pages: none

    image.png

    TARGET MODULE

    rows: cost element list

    columns: fab category list

    pages: belongs to fab category? line item

    image.png

  • Dikshant
    Dikshant

    Hey, that helps. I got the requirement now, and I built the solution as well. Let me know if you have any questions about the same.

    image.png
    image.png

    Blueprint View:

    image.png

    Using my all time favorite function, ANY😉 I try to use it all the places…

    Let me know if there are any questions!

  • LucaRicci
    LucaRicci

    @Dikshant seems to be working! thanks a lot!!

Categories