Using the Cell Editor
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:
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.
Here is how the statement would look:
( (Act#600000 == 0) * (Act#601500 + Act#620300) ) + ( (Act#600000 <> 0) * Act#6000000 )