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 but clearly not (unless I am missing something). Any suggestions?

Thanks,

Adam

 

3 Replies

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

  • 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.