Using the DIVIDE Function

[micklowe]

Hi

I'm having a few problems with the NaN and Infinity errors on a calculation field, I believe the solution is to use the DIVIDE function but I'm having problems getting this to work. 

This is the current calculation:

Utilisation = CALCULATE([productive_time]/([WorkingHours]-[non_productive_time]))*100

Is it possible to rewrite this as a DIVIDE or do I need to create a new calculated field for "WorkingHours - non_productive_time?

Thanks for any help.

Mick

[micklowe]

Thanks Harish, this worked perfectly, I did have to remove the equals sign to get it to work but the divide by zero errors are now gone 🙂

Final code looks like this:

Utilisation = 
Var _a = [productive_time]
VAR _b=( [WorkingHours]-[non_productive_time])

return

divide(_a,_b,0)*100

[HarishKM · Accepted solution]

@micklowe Hey,
you can write your dax like this.
Utilisation = 
Var _a = [productive_time]
VAR _b=( [WorkingHours]-[non_productive_time])

return

 = divide(_a,_b,0)*100


you can try above dax.

Thanks

Harish M

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.