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]))

daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

divide( [ASP], [ASP] ) * divide( [Plan ASP], [Plan ASP] ) * divide([ASP]-[Plan ASP],[Plan ASP])

 

... and don't ask me why.