Conditional If then to return values for rangesI have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number 19,20,21,22,23,24,25,26,27 etc.)
AnalyticsData TableRe: Conditional If then to return values for rangesPerhaps this is a starting point, it checks, if the number of runs per campaign is greater or equal 9 days. However, it does not check whether days are consecutive, that's possible, but more complex. If that's needed, it would be really better if you could provide examples.
Key is the function "Col Number", see Scripting Index for details.
Re: Conditional If then to return values for rangesI am not understanding exactly what you are looking for. Could you please provide a sample data table with the values you expect to see?
