AnsweredAssumed Answered

Simplify equation

Question asked by Tom_Droz on Feb 5, 2019
Latest reply on Feb 6, 2019 by user19752

I have a field that calculates an output based on how many photos there are, up to 50.  I have a formula that works but seems like too much.  Is their and easier way to do this?  Each photo is name 1=a, 2=b, 27 za

 

Thanks for any thoughts on a more elegant solution!

 

Case ( VEHICLES::Photo_Count>0 ;
Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "a" & ".jpg"; "")  &

Case ( VEHICLES::Photo_Count>1 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "b" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>2;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "c" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>3 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "d" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>4;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "e" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>5 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "f" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>6;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "g" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>7 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "h" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>8;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "i" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>9 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "j" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>10;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "k" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>11 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "l" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>12;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "m" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>13 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "n" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>14;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "o" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>15 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "p" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>16;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "q" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>17 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "r" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>18;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "s" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>19 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "t" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>20;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "u" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>21 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "v" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>22;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "w" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>23 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "x" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>24;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "y" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>25 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "z" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>26;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "za" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>27 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zb" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>28;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zc" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>29 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zd" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>30;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "ze" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>31 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zf" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>32;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zg" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>33 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zh" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>34;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zi" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>35 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zj" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>36;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zk" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>37 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zl" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>38;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zm" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>39 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zn" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>40;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zo" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>41 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zp" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>42;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zq" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>43 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zr" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>44;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zs" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>45 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zt" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>46;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zu" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>47 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zv" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>48;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zw" & ".jpg" ; "")  &

Case ( VEHICLES::Photo_Count>49 ;
"," & Vehilces_X_Global Storage::Auto Photo Location & VEHICLES::__kp_Stock Number & "zx" & ".jpg" ; "")

Outcomes