RobDunbar
-
Posts
3 -
Joined
-
Last visited
RobDunbar's Achievements
-
Case Statement in Formula of Table
RobDunbar replied to RobDunbar's question in Calculations and aggregations
What I am tring to do is to create a destination URL but I have two different URLs that are possible and each page has a different set of variables -
Case Statement in Formula of Table
RobDunbar replied to RobDunbar's question in Calculations and aggregations
All are Integers -
Hello All, I am stumped. I have the following case statement in a formula field and it verifys. CASE WHEN [@field:SMNType] = 1 THEN 'l1q1.html?XBSPropertyID=' + [@field:SMNPropertyID] + '&;VRRYear' + [@field:SMNYear] WHEN [@field:SMNType] = 2 THEN 'l1q2.html?XBSPropertyID=' + [@field:SMNPropertyID] + '&;VRRYear' + [@field:SMNYear] WHEN [@field:SMNType] = 3 THEN 'l1q3.html?XBSPropertyID=' + [@field:SMNPropertyID] + '&;VRRYear' + [@field:SMNYear] WHEN [@field:SMNType] = 4 THEN 'l1q4.html?XBSPropertyID=' + [@field:SMNPropertyID] + '&;VRRYear' + [@field:SMNYear] WHEN [@field:SMNType] = 8 THEN 'b1.html' ELSE '' END However, when I try to save the table I get Unable to save table due tto incompatible values in one or more formula fields.
