on 10-05-2007 6:24 PM
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.
Here is how the statement would look:
( (Act#600000 == 0) * (Act#601500 + Act#620300) ) + ( (Act#600000 <> 0) * Act#6000000 )
Cheers,
Rusty
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.