Forum Discussion

AdamRobC's avatar
AdamRobC
Icon for Helper II rankHelper II
5 years ago
Solved

Return blank values when one value in a division calculation doesn't exist

Hi there, Please refer to the below screenshot. I would like the value under variance to be blank when the actual values don't exist. I thought I could achieve this via the DIVIDE function alone bu...
  • amitchandak's avatar
    amitchandak
    5 years ago

    AdamRobC , Try like

     

    if(isblank([ASP]), blank(), divide([ASP]-[Plan ASP],[Plan ASP]))

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

AdamRobC , Try like

 

if(isblank([ASP]), blank(), divide([ASP]-[Plan ASP],[Plan ASP]))

AdamRobC's avatar
AdamRobC
Icon for Helper II rankHelper II
5 years ago

Great, works perfectly