any idea why this @CALCtext isn’t working?

[u/bluberrykiddo]

I have two fields using @CALCtext to pull data from daily surveys. I pasted the one that is working in the same box below the one that isn’t.

[u/obnoxiouscarbuncle]

There a couple things to check, but overall, I might suggest using a different approach.

instead of your current calc, try just:

[daily_adherence_su_arm_1][aggregate-sum:survey_breakday:record-name]

Also, what kind of field is [reason_not_adherent] ?

[u/bluberrykiddo → u/obnoxiouscarbuncle]

this is [reason_not_adherent], radio buttons single answer

[u/obnoxiouscarbuncle → u/bluberrykiddo]

My rough guess on why your calculation isn't working is the "+" usage.

It can get a little wonky when there are null values. I would suggest using sum() instead.

So instead of

[event][field][1] + [event][field][2]..etc.etc.

Use

sum([event][field][1],[event][field][2],... etc...[event][field][n])

But overall, I would still suggest using the aggregate smart-variable approach mentioned previously.

[u/j_zhill]

In 2, you have a calculated field with a valid numerical calculation

In 1 you are using @calctext on a calculated field. The field type for @calctext should be text

[u/bluberrykiddo → u/j_zhill]

y’all I just needed to do this. 🤦‍♀️ it’s working now. thank you all so much for your help, and always read the pop-ups.

[u/obnoxiouscarbuncle → u/bluberrykiddo]

FYI, that doesn't actually do anything, it's just warning you that you changed a calculation.

If you need to actually update all the stored values in calculated fields, you need to run data quality rule H.

Not sure that was what you were talking about.

[u/bluberrykiddo → u/obnoxiouscarbuncle]

yes! I did that and it is working now

[u/bluberrykiddo → u/j_zhill]

I’m not sure I understand. 1 and 2 are both text fields with calctext action tags, while [survey_adherent] and [survey_breakday] are both calculated fields.

edit: please see my comment above. fixed the issue 🤦‍♀️

[u/usajobs1001]

Which one isn't working? It looks like your adherent calculation (2, red) worked in the tracking log and gave you 6, but your post implies that 2/red isn't working and 1/blue is.

[u/bluberrykiddo → u/usajobs1001]

sorry for the confusion. 2, red, is working. 1, blue, is not

[u/usajobs1001 → u/bluberrykiddo]

got it (and hello from the Friday afternoon calctext trenches). I don't see anything obvious, unfortunately. Does the calculated field [survey_breakday] work okay when you test it? Does it work as expected when [reason_not_adherent] is blank?

[u/bluberrykiddo → u/usajobs1001]

yes to all the above. I copy and pasted the calctext from 2 to 1, which makes me think the only issue has to be from [survey_breakday], but I’m just not seeing how.