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

[annafuksa1]

use in your formula formula

=if(expression<0,0 expression)

example

expression = count(POINTS DEDUCTED)

=if(count(POINTS DEDUCTED)<0,0 count(POINTS DEDUCTED))

if want to show only positive values (so if you have -1 show as 1) use function for absolute value -'Fabs'

Anna

[vishsaggi]

May be this?

For each category

= Count(Distinct {< [SLA Impact] = {'High'} >} ID) > 0

= Count(Distinct {< [SLA Impact] = {'Low'} >} ID) > 0

......

Let us know if that works?

[aarkay29]

Hi Dan,

If(100-[Points Deducted]>0,100-[Points Deducted]) as expression for Category Score.

Similarly for Points deducted too

[=IF(

[Close Period]>'2016 - 01',

         If(Critical *(10) + (High*(5))+ (Medium *(3)) + (Low *(1))>0,Critical *(10) + (High*(5))+ (Medium *(3)) + (Low *(1))),

               If(Critical *(10) + (High*(5))+ (Medium *(3)) + (Low *(0))>0,Critical *(10) + (High*(5))+ (Medium *(3)) + (Low *(0))>0)

)

[Anonymous]

Anna & Vishwaqrath,

These do not give me what I need- not sure it is even possible.

In the Table included, the TIMELINES POINTS DEDUCTED is -69.  Even thou the actual calculation is -69, I want it to show 0 if the number is a negative number.

Dan

[annafuksa1]

can you post the app  or the full formula ?

i

[annafuksa1]

My formula should do the trick

[vishsaggi · Accepted solution]

May be try this?

= IF(100 - [Points Deducted] < 0, 0, 100- [Points Deducted])

[aarkay29]

If(100-[Points Deducted]>0,100-[Points Deducted],0) as expression for Category Score. Use this if you want to show 0 if negative

[Anonymous]

rangemax(yourexpression,0)