VMware Cloud Community
MattG
Expert
Expert
Jump to solution

How to set minimum value for division in Super Metric function?

I want to create the following Super Metric:

(Datastore Read KB / Write KB )*100

To get an understanding of the ratio of reads to writes.   However,  this equation will always come up 0 if either number is 0. 

Is there a way to say "If read=0 then read=1" so that the equation will not evaluate to 0?

Thanks,

-MattG

-MattG If you find this information useful, please award points for "correct" or "helpful".
Tags (2)
Reply
0 Kudos
1 Solution

Accepted Solutions
admin
Immortal
Immortal
Jump to solution

There is no "if" statements...but was thinking that you can add a  (metric value + 0.0001)  that should then not be 0

View solution in original post

Reply
0 Kudos
1 Reply
admin
Immortal
Immortal
Jump to solution

There is no "if" statements...but was thinking that you can add a  (metric value + 0.0001)  that should then not be 0

Reply
0 Kudos