Setting Up Alerts on Table Calculations that are based on other Table Calculations

[Jun_Lee]

When I set up an alert based on the table calculation shown below, the alert does not get triggered. Is it because the table calculation is based on other table calculations? I am not sure how to fix this issue.

Threshold Breach Table Calculation:
if(${check_record} AND ((${form_completion_rate} < ${lower_limit}) OR
(${.form_completion_rate} > ${upper_limit})),
${form_completion_rate} , null)

Table Calculations that are embedded in Threshold Breach:

Lower Limit:
${pv_to_rfq_progression_8_week_rolling_average} - 3*${std_dev}

Upper Limit :
${pv_to_rfq_progression_8_week_rolling_average} + 3*${std_dev}

Check Record (Returns “yes” for the most recent week in order to set up an moving alert):
${mvp_reporting.event_week} = to_date(substring(to_string(add_days(-
mod(diff_days(${mvp_reporting.event_week}, now()), 14), now())),0,10))

8 Week Rolling Average:
sum(offset_list(${mvp_reporting.rfqs},0,8)) / sum(offset_list(${mvp_reporting.form_visitors},0,8))

Form Completion Rate is a measure

Any alerts that are set up based on the Threshold Breach Table Calculation does not trigger any conditions, even though it shows up on the visualization. Changing the percentage values to numbers did not help. Would be happy to give any further explanation. Thanks!

[Cyril_MTL_Analy]

Hi @Jun_Lee, are you using the decimal format for your alert threshold like >0.3 (and not >30%)?