Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Add rows to table that repeats unique column countdown starting from value in another column, for a set number of times.

Having trouble figuring out the direction I need to go for this table I want to make.  Will continue to research functions but wanted to pose the general question to the community. I have this table...
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

please give an example of toollife and currentlife values combination that gives wrong result (or error).  

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

I got this to work now by adjusting the custom function like so:

fx_tools_add_positions = (r as record, parts as number) as record => 
        if r[Currentlife]=r[Toollife]
        then
        Record.AddField(
            r,
            "positions",
            List.InsertRange(
                 List.Numbers(
                r[Currentlife]+1, 
                Number.RoundAwayFromZero(parts / r[Toollife]), 
                r[Toollife]),0,
                List.Numbers(1,1)
            )
        )
        else
        Record.AddField(
            r,
            "positions",
            List.Numbers(
                r[Currentlife]+1, 
                Number.RoundAwayFromZero(parts / r[Toollife]), 
                r[Toollife])
        )
        ,