Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,760
Community Members
 
Community Events
168
Community Groups

how to check if value of original estimate is zero before doing calculated measure

so i am creating a calculated measure that will return variance between actual Log hours vs Orignal estimates, but in case if  my actual is zero it returns infinity , so before doing my calculation i want to check that only if the value of my measure field is non zero then do calculation

2 answers

1 accepted

2 votes
Answer accepted

Hi @Sakina ,

 

I recommend implementing a condition with the CASE statement before the calculation and checking whether the actual logged hours are greater than zero. Some of the predefined calculated measures have such a condition. Please view the formula of the measure "Average resolution days" as an example.

CASE WHEN [Measures].[Issues resolved] > 0 THEN
[Measures].[Total resolution days] / [Measures].[Issues resolved]
END

See the eazyBI documentation page on defining calculated measures here - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures.

 

Best,

Roberts // support@eazybi.com

@Roberts Čāčus  that's what i did 😀

Like Roberts Čāčus likes this

hi @Alex Koxaras 

thank but, i got the other way around

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events