Special way of remaining story point calculation

Hi guys,

I’m new to EazyBI and it seems like I’m completely stuck trying to calculate some of the remaining estimates on an epic level.
I’ve defined 4 groups of statuses:

  • ToDoState - couple of statuses
  • InProgressState - couple of statuses
  • TestingState - couple of statuses
  • DoneState - couple of statuses
    I want to calculate story points remaining for each epic in the following way:
    If story in ToDoState or InProgressState - take original amount of StoryPoints
    If story in TestingState - text half of original StoryPoints
    Take zero for the Done state.

*And also I’m in doubt about how to calculate amount of unestimated stories