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

[AdamRobC]

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

[daxer-almighty]

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

... and don't ask me why.

[amitchandak · Accepted solution]

@AdamRobC , Try like

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

[AdamRobC]

Great, works perfectly