Dynamic FILL_KILL
-
MrJoeBlack
- Posts: 45
- Joined: Sun Jun 26, 2016 7:58 pm
Is it possible to use a cell reference for the FILL_KILL delay in the command string?
-
jamesedwards
- Posts: 4541
- Joined: Wed Nov 21, 2018 6:16 pm
I would think so. You can use cell references in Excel formulas so I see no reason why not.MrJoeBlack wrote: ↑Fri Oct 03, 2025 7:47 pmIs it possible to use a cell reference for the FILL_KILL delay in the command string?
-
MrJoeBlack
- Posts: 45
- Joined: Sun Jun 26, 2016 7:58 pm
I have a dynamic calculation based on memory decay (i.e. duration of momentum) rounded to a whole number - but whenever I reference the cell as part of the string the status returns an ERROR.
-
jamesedwards
- Posts: 4541
- Joined: Wed Nov 21, 2018 6:16 pm
I don't use excel with BA very much, and haven't ever used fill/kill. You say that you round it to a whole number, I wonder whether it needs to be x.x rather than just x ?MrJoeBlack wrote: ↑Sat Oct 04, 2025 10:58 amI have a dynamic calculation based on memory decay (i.e. duration of momentum) rounded to a whole number - but whenever I reference the cell as part of the string the status returns an ERROR.