Forum Discussion

newgirl's avatar
newgirl
Icon for Post Patron rankPost Patron
4 years ago
Solved

Subtract a value from a measure

Hello!   In this report I'm developing, I've created lots of initial measures. The next measure I need is subtract 24 from a specific measure. When I input  Pack1_WorkingTim = 24 - fSolidPackhou...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    newgirl , Try like

    if(isblank([Pack1_TotDowntime]), blank(), 24 - fSolidPackhouse[Pack1_TotDowntime])

     

    addition of value can force left join with dimension

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

newgirl , Try like

if(isblank([Pack1_TotDowntime]), blank(), 24 - fSolidPackhouse[Pack1_TotDowntime])

 

addition of value can force left join with dimension

newgirl's avatar
newgirl
Icon for Post Patron rankPost Patron
4 years ago

Thanks amitchandak ! It worked! Can you explain more about what you said "addition of value can force left join with dimension" ? I didn't know about this.