Skip to Content
0
Feb 08, 2017 at 03:44 AM

Key figure formula facing in Excel front end

155 Views

Hello,

I have a formula like this which looks OK with no error and correct calculation graph but Excel throws an error. Can somebody tell me why?

For me it looks a simple one but is not working.

Thanks,

Subash Nanjangud

S4PRODNRATE @PERPRODLOCRESSRC = IF ( ( "EPPULLRATE @PERPRODLOCRESSRC" = 0 OR ISNULL( "EPPULLRATE @PERPRODLOCRESSRC" ) OR "EPEFFIENCY @PERPRODLOCRESSRC" = 0 OR ISNULL( "EPEFFIENCY @PERPRODLOCRESSRC" ) ),NULL, "EPPULLRATE @PERPRODLOCRESSRC" * "EPEFFIENCY @PERPRODLOCRESSRC" * 24)