Simplified Field Notation using a not so simple formula

I am trying to write a Simplified Field Notation using the formula below. Can someone tell me what is wrong with this formula?

((EXPECTED REVENUEA * INTENDED QUANTITYA)-COST BASIS VALUEA)*SHAREA

This topic has been closed for replies.

Correct answer George_Johnson

try67 meant "backslash" instead of "back-space", so it should look like:

((EXPECTED\ REVENUEA * INTENDED\ QUANTITYA) - COST\ BASIS\ VALUEA) * SHAREA

Inspiring

try67 meant "backslash" instead of "back-space", so it should look like:

((EXPECTED\ REVENUEA * INTENDED\ QUANTITYA) - COST\ BASIS\ VALUEA) * SHAREA

Community Expert

Damn, my mistake. Thanks for the correction!

Community Expert

You need to add a back-space before each space inside a field's name...

I recommend you switch over to using JavaScript if your formulas are not so simple, though.

Participant

Thank you so much!!

Sign up