Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF(ISBLANK(

Hi,   At first i had a simple divide to work out the % of cosistency ([Number of Consistent]/[Num Overscore]) however it wasnt accurate for ones that have 0% so i used an if formula if([Number of C...
Need Help
Tips and Tricks
  • AnthonyTilley's avatar
    AnthonyTilley
    7 years ago

    If your problem is a divide by zero issue the use divide function instead of "/"

    instead of [Number of Consistent]/[Num Overscore] use 

    measure = DIVIDE([Number of Consistent],[Num Overscore],0) this will handle divide by zero issues

    if you want to replace a value of 0% with a new value then use 

    Measure =

    var d = DIVIDE([Number of Consistent],[Num Overscore],0)

    var ret = if(d = 0,
    blank(),
    d)
    Return ret
AnthonyTilley's avatar
AnthonyTilley
Solution Sage
7 years ago

If your problem is a divide by zero issue the use divide function instead of "/"

instead of [Number of Consistent]/[Num Overscore] use 

measure = DIVIDE([Number of Consistent],[Num Overscore],0) this will handle divide by zero issues

if you want to replace a value of 0% with a new value then use 

Measure =

var d = DIVIDE([Number of Consistent],[Num Overscore],0)

var ret = if(d = 0,
blank(),
d)
Return ret