Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 05, 2007 at 08:00 PM

    Here is how the statement would look:

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

    Cheers,

    Rusty

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Oct 25, 2007 at 09:39 PM

    Thanks for your help.

    Add comment
    10|10000 characters needed characters exceeded