My calculated fields are working correctly in one environment but it throws a syntax error after being deployed to another environment.
( sum(Field 1) / sum(Field 2) ) *0.9 = Field 3
sum(Field 4) / Field 3 = Field 5
( 515,479 / 2,835 ) * 0.9 = 163.64
5,252 / 163.64 = 32.09
the visuals have been moved around a little in the second picture.
the names are the same though if you can follow that.
Can you please try the following formula.
sum(Field 4) / (( sum(Field 1) / sum(Field 2) ) * 0.9 ) = Field 5
Hi @ryan,
This is not the ideal case, but if you’re still facing issues, please check with your field as there may be some minor issues.
Thanks & Regards
Biswajit Dash
Please check if there is any additional filter on that particular field, also check the calculated field for that card, what is appearing in the calculating field after deployment.
Hi @Xclipse this was the correct solution. For some reason it worked fine when the fields were separated in Dev but it worked when they were combined in one calculation for other environments.
Thank you very much!
Thank you so much for confirming!