Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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
Super User
3 years ago

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

When I input 100 for a tool life and 2 for a current life, the first "1" set for that tool was at part #98, then every 100 parts# after that.

  • AlienSx's avatar
    AlienSx
    Super User
    3 years ago

    need to change initial value in that function

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