Help

Compress my formula please

Topic Labels: Formulas
800 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Breight_Group
6 - Interface Innovator
6 - Interface Innovator

I have a base with over 1200 number fields and a few text fields. Is there a better way to sum all number fields that start with “M”? At the moment i am using the below formula which i regularly need to update every time i add a new field.

SUM(M001+M002+M003+M013+M018+M019+M031+M032+M036+M039+M040+M042+M043+M045+M047+M048+M049+M050+M051+M052+M053+M055+M056+M057+M058+M059+M060+M062+M063+M064+M065+M066+M067+M068+M071+M072+M073+M074+M075+M083+M084+M087+M095+M096+M097+M099+M100+M101+M103+M104+M105+M112+M113+M116+M117+M123+M125+M126+M127+M128+M129+M135+M136+M141+M163+M172+M186+M187+M202+M206+M207+M208+M209+M210+M211+M212+M213+M214+M215+M216+M217+M218+M219+M220+M221+M222+M223+M224+M258+M280+M290+M294+M317+M327+M330+M331+M332+M333+M336+M363+M364+M373+M579+M580+M581+M583+M584+M585+M587+M589+M590+M592+M593+M594+M595+M597+M598+M599+M600+M601+M602+M603+M604+M605+M606+M608+M611+M612+M613+M614+M615+M617+M618+M619+M620+M622+M623+M624+M625+M626+M627+M628+M629+M630+M631+M632+M633+M634+M635+M636+M637+M638+M639+M640+M641+M642+M643+M644+M645+M646+M647+M648+M649+M650+M651+M652+M653+M654+M655+M656+M657+M658+M659+M660+M661+M662+M663+M664+M665+M666+M667+M668+M669+M670+M671+M672+M673+M675+M676+M681+M683+M684+M685+M686+M687+M689+M691+M693+M694+M695+M698+M699+M703+M704+M705+M706+M707+M708+M709+M710+M711+M713+M714+M715+M716+M717+M718+M721+M722+M724+M725+M726+M728+M729+M730+M738+M746+M747+M751+M761+M767+M768+M772+M773+M774+M775+M776+M777+M778+M779+M800+M801+M802+M803+M804+M806+M807+M812+M813+M823+M824+M826+M827+M832+M834+M836+M837+M841+M842+M843+M844+M845+M846+M854+M856+M857+M862+M866+M867+M868+M869+M870+M874+M876+M877+M879+M880+M881+M885+M894+M895+M896+M899+M900+M901+M902+M906+M912+M916+M928+M929+M933+M936+M937+M938+M942+M944+M945+M946+M949+M953+M954+M956+M957+M958+M959+M960+M961+M962+M966+M967+M968+M970+M971+M973+M975+M977+M978+M979+M980+M981+M984+M985+M990+M994+M1004+M1005+M1006+M1011+M1016+M1017+M1023+M1024+M1025+M1029+M1032+M1033+M1034+M1035+M1039+M1040+M1041+M1042+M1045+M1046+M1047+M1052+M1053+M1054+M1055+M1056+M1057+M1060+M1061+M1063+M1064+M1066+M1067+M1071+M1072+M1073+M1074+M1075+M1076+M1077+M1078+M1081+M1082+M1083+M1084+M1085+M1086+M1087+M1088+M1089+M1090+M1091+M1092+M1093+M1094+M1095+M1096+M1097+M1098+M1099+M1100+M1101+M1102+M1103+M1104+M1105+M1106+M1107+M1108+M1109+M1110+M1111+M1112+M1113+M1114+M1115+M1116+M1117+M1118+M1119+M1120+M1121+M1122+M1123+M1124+M1125+M1126+M1127+M1128+M1129+M1130+M1131+M1132+M1133+M1134+M1135+M1136+M1137+M1138+M1139+M1140+M1141+M1142+M1143+M1144+M1145+M1146+M1147+M1148+M1149+M1150+M1151+M1152+M1153+M1154+M1155+M1156+M1157+M1158+M1159+M1160+M1161+M1162+M1163+M1164+M1165+M1166+M1167+M1168+M1169+M1170+M1171+M1172+M1173+M1174+M1175+M1176+M1177+M1178+M1179+M1180+M1181+M1182+M1183+M1184+M1185+M1186+M1187+M1188+M1189+M1190+M1191+M1192+M1193+M1194+M1195+M1196+M1197+M1198+M1199+M1200)

Is there a way around not having to type all the field names?

Appreciate any help here

Thank you in advance

0 Replies 0