how to calculate total with exculde some row

[chipmunkG]

Hi,

Kindly help me how to calculate  total of score with exclude the yellow color.

[SharathPanackal]

Hi ChipmunkG,

Is there any criteria to arrive at the higlighted rows? if you can share that logic it might help in bringing up a solution.

Regards,
Sharath Panackal

[shiveshsingh]

Hi May be you can exclude these figures in dimensions itself..like If(Speed<>'Others',Speed) as Speed

[chipmunkG]

when i'm try this one "If(New_Speed <>'Others',New_Speed) ", the exactly result i want.

but when i'm try " If(New_Speed <>'Others',New_Speed, If(New_Speed <>'10Mbps',New_Speed)  ", the code is not working.

[SharathPanackal]

Hi ChipmunkG,

Hope it is just a syntax issue since i see you haven't closed the second paranthesis.
Please try If(New_Speed <>'Others',New_Speed, If(New_Speed <>'10Mbps',New_Speed))

Regards,
Sharath Panackal

[chipmunkG]

ops! my typo. actually in my code has the one. but still not working.

[shiveshsingh · Accepted solution]

Hi Try like this If(New_Speed <>'Others' and New_Speed <> '10Mbps' ,New_Speed)

[chipmunkG]

yessss. that is great!!!!!! thank you so much sir!

 

[shiveshsingh]

Perfect, please close the thread 🙂