I am using this expression in order to link each row with quickbooks. Basically I need each row to have a value of M_T_1, M_T_2, M_T_3, M_T_4, M_T_5. I used this expression to do this as an initial value.
โM_T_โ&(COUNT(SELECT(bol_manpower[unique_id], [job_uid] = [_THISROW].[job_uid]))+1)
Simple enoughโฆ but the only issue could be if letโs say I delete the row with M_T_2. Then when I add the next row I will have two M_T_5 values. How can I change the expression to understand I am missing the M_T_2 value?
Count(select(bol_manpower[unique_id],
and([job_uid] = [_THISROW].[job_uid],
[_rowNumber]<=[_thisrow].[_rownumber])
))
This is getting closer but still not there. With this, you have to resync every row to get the columns to match
You may wish to take a look at the tip by @Steve
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |