cancel
Showing results for 
Search instead for 
Did you mean: 

Using the Cell Editor

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Here is how the statement would look:

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

Cheers,

Rusty

Former Member
0 Kudos

Hi Rusty,

Your anser was very helpful, thank you. But let me throw a couple of quick ones out there.

I didn't notice any kind of 'ELSE' statements under the boelan category, is that why you used the '+' sign instead?

Could you have easily just used the 'OR' statement, or would it have had a different effect on the results?. For example:

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

Also I noticed you used double brackets in the formula, like at the end of the Act#620300, and at the begining of Act#600000. Why is that? Is it because it's a kinf of condition to the formula??

And one final thing, hve you seen this erros message before?

"Query contains recursive definitions that cannot be broken down. Please start the examination in the cell / Nov &ZT_FYEAR&, EB Plan."

Formula in eht cell is as follows: Begining bal + Revenue - Reciepts + bad debts + VAt on bad Debts.

So I'm confused where the recursiveness is occuring.

Thanks a million.

I promise max point

Message was edited by:

Ehab Mansour

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks for your help.