Only Red Color Values sum - Table Box

[Ramu]

Hi All ,

Can you please help me. My Requirement is

This is table box .

In that table, In that A=A,B=B ,C=C... Displaying Green color .

Remaining things  displaying the value >=5 Red Color , and remaining Blue color .

My problem is  :- above screen shot total filed is there in that i want to displaying only the sum of Red color values.

Note*: I have used if condition, But code is number of line is there ,each line having 15 if condition (Possible combination).
Is there any way to solve the issue.

Thanks ,

Ram

[Frank_Hartmann]

see attached qvw.

hope this helps

[Brett_Bleess]

Frank seems to have given you full solution, so I just wanted to let you know to be sure to return to the thread and use the Accept as Solution button on Frank's post if his sample app gets you what you needed for your use case.  This gives him credit for the help and lets the other Community Members know it worked.  If you have further questions, leave an update post.

Regards,
Brett