Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using the Cell Editor

Hi experts,

I have a relatively straight forward question regarding the cell editor in my query. I'm not that familiar with the operand contained in the formula, so that's where I need the help. The scenarios goes like this:

Example:

In my query, if a particular row, say for example account # 600000 is blank (no dollar amounts, or = 0), I want to the system to calculate a value for # 600000 based on a particular formula that I have. So the logic of the cell should go like this:

If account # 600000 is equal to zero (no value), then account # 600000 should be calculated as follows, # 600000 = account # 601500 + account # 620300. Otherwise the formula should not be used if there is already an value in that cell for # 600000.

How do I put this into the cell editor logic using the various operand.

Many thanks to all.

Former Member
Former Member replied

Here is how the statement would look:

( (Act#600000 == 0) * (Act#601500 + Act#620300) ) + ( (Act#600000 <> 0) * Act#6000000 )

Cheers,

Rusty

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question