Make 0 lowest amount

[Anonymous]

The below Straight Table is calculating several thing(see below).

I am looking for either the POINTS DEDUCTED or CATEGORY SCORE to go no lower than 0 or 0%.

Step

1) Count each CATEGORY for EACH SLA

2) Calculate POINTS DEDUCTED

3) Calculate CATEGORY SCORE

[Anonymous]

Anna, Aar & Robin,

All of your expressions worked!

Thank You!!!

Dan

[sunny_talwar]

A slightly more efficient apporach (as pointed out by roharoha‌) would be to use RangeMax() here

RangeMax((100 - [Points Deducted]), 0)