Didn’t get you exactly, but you can consider using the below, which may help you to give some direction,
XXX - whatever the value you wish to return in the else case.
This is very helpful. I've been screwing around with it so let me clarify a little more. I want this to be dynamic. I can't hard code any node names into the formula.
Does this help?
Looking at node XX_1234
Property Export_DW = Y (for node XX_1234)
Node 1234 (different node in the hierarchy)
with Property XX_Account = XX_1234
I don't even know if this type of formula is possible. I could handle it in SQL in a heartbeat and then just create an action script to upload but I don't have a staging area just yet.....
Need to check, something I have in mind at present ( even I didn't like it, if nothing works out this might be helpful:-) ),Create a validation of class "Hierarchy contains all where Prop = TRUE" and use it part of a export, If exort contains any records, write a batch to execute an Action script with required property update, will see if I can come up with something over the weekend!
I believe having read your earlier two posts that on an account PQRS (Where P, Q, R, S are numbers) you have a property XX_Account( Where XX_ is a fixed prefix???) and this property can have only two values ( NULL or XX_Abbrev()).
(Where XXX is the Else condition you wana specify)
I am hoping to have read your query correctly and that this helps.