A division by zero has been encountered

[frankee_gee]

Hello Everyone, Needed some help with this error

MdxScript(Model) (6,54) Calculation error in measure 't_Track'[Spend/ErectLegFT]. A division by zero has been encountered.

This is the formula:

Spend/ErectLegFT:=CALCULATE([LaborSpend]/[ErectLegFT],lu_ActivityType[ActivityDesc]="Erect")

Was working well in 2015Q3. But now during 2015Q4, is is no longer working

I would prefer to find the errors and correct them, because all it means is that data is missing and I would need to fill in at some point thru a manual reconcile process.


How can I capture where this error is occurring?

If it's not possible to capture where the error is occurring, I found this possible solution after some research, it was suggested to use Divide function because it ignores ZERO's

Not sure how to use the filter for the last part of the original Calculate function: lu_ActivityType[ActivityDesc]="Erect"

it would look something like this :

Spend/ErectLegFT:=DIVIDE([LaborSpend],[ErectLegFT])

where or how do I add the following filter :

lu_ActivityType[ActivityDesc]="Erect"

Many thanks for your help in advance.

Frank.

 

[frankee_gee]

I was able to get this working using this formula:

Spend/ErectLegFT:=CALCULATE([LaborSpend]/[ErectLegFT],lu_ActivityType[ActivityDesc]="Erect")

but now the slicers don't function as expected.


So will need help with finding what is data is causing the error: "A division by zero has been encountered"

Thanks again.

Frank.

 

[SimonNU]

I'm not entirely sure this is what you're after, but give it a shot:

Spend/ErectLegFT := CALCULATE ( DIVIDE (SUM ( [LaborSpend] ), SUM ( [ErectLegFT] ) ), lu_ActivityType[ActivityDesc]="Erect" )

 

[frankee_gee]

Thanks Simon - I attempted to use this formula and it returned errors. nothing ever calculated.