Help me to make improve this code

[#1]

Dears, I'm actually using the following code to calculte the favorability of a item. But I'm seeing that it's taking to much time to calculate and I do belive that I can do it better. So, Do you have any sugestion to calculate it in another way?

=
(
((((Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Extremely Satisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness]))
-(Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Extremely Unsatisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Convenient locations])+Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Convenient locations]))
-(Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Convenient locations])+Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Convenient locations])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Overall experience])+Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Overall experience]))
-(Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Overall experience])+Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Overall experience])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Slot availability])+Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Slot availability]))
-(Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Slot availability])+Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Slot availability])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Workmanship])+Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Workmanship]))
-(Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Workmanship])+Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Workmanship])))))
)

/

(
((((Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness]))
+(Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Neutral"}>} [ Embraer Owned Service Center Network  AOG responsiveness])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Convenient locations])+Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Convenient locations]))
+(Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Convenient locations])+Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Convenient locations])+Count({$<[ Embraer Owned Service Center Network  Convenient locations] = {"Neutral"}>} [ Embraer Owned Service Center Network  Convenient locations])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Overall experience])+Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Overall experience]))
+(Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Overall experience])+Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Overall experience])+Count({$<[ Embraer Owned Service Center Network  Overall experience] = {"Neutral"}>} [ Embraer Owned Service Center Network  Overall experience])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Slot availability])+Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Slot availability]))
+(Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Slot availability])+Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Slot availability])+Count({$<[ Embraer Owned Service Center Network  Slot availability] = {"Neutral"}>} [ Embraer Owned Service Center Network  Slot availability])))))
+
((((Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Satisfied"}>} [ Embraer Owned Service Center Network  Workmanship])+Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network  Workmanship]))
+(Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network  Workmanship])+Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network  Workmanship])+Count({$<[ Embraer Owned Service Center Network  Workmanship] = {"Neutral"}>} [ Embraer Owned Service Center Network  Workmanship])))))
)

Thank you so much for your attention,

Best regards

[#2]

On a quick look I can advice you that set analysis can accomodate multiple conditions bringing down your code size. For example your first term

Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Extremely Satisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])

Can be replaced with

Count({$<[ Embraer Owned Service Center Network  AOG responsiveness] = {"Satisfied","Extremely Satisfied"}>} [ Embraer Owned Service Center Network  AOG responsiveness])

Hope it helps,
Kiran

[llauses243]

Hi,

For me much code make dificult test & maintenance

To divide in columns and each a expression improvement in clearity moreover easy test & maintenance

By In-memory not affect the performance

Pls to see object attached for more info.

Good luck, Luis.

Is possible also to use variables