-
1. Re: IF("Gross Sales"==#missing) - not working
2625007 Jul 8, 2018 9:27 AM (in response to 2625007)Gross Sales is account member - Never Share.
-
2. Re: IF("Gross Sales"==#missing) - not working
ManojPavan-Oracle Jul 8, 2018 11:13 AM (in response to 2625007)Hello,
Instead of the following can you hard code a member and see if it works?
@MEMBER(@CONCATENATE("MISC-",@NAME(@SUBSTRING(@NAME(@CURRMBR("Product")),2,6)))
-
3. Re: IF("Gross Sales"==#missing) - not working
user9928941 Jul 8, 2018 1:24 PM (in response to 2625007)Hi,
You don't need the outer @NAME. @CONCATENATE("MISC", @SUBSTRING(....)), should do the work.
SUBSTRING returns a string, while NAME takes an essbase "member" parameter which you are getting using @CURRMBR.
Thanks,
Pawan.
-
4. Re: IF("Gross Sales"==#missing) - not working
2625007 Jul 8, 2018 1:57 PM (in response to ManojPavan-Oracle)not working!
something is a problem with comparison with #missing... not sure where is the issue
-
5. Re: IF("Gross Sales"==#missing) - not working
2625007 Jul 8, 2018 1:58 PM (in response to 2625007)Even this code doesn't work!
FIX("Actual","May",&ActYear)
FIX("P_G1050")
FIX("Total Customer","Total Departments","Final")
"Other COGS"
(
IF("Material Cost" == #Missing)
"Other COGS"->"MSC"->"MISC-G105"->"Departments_NA" = 111;
ENDIF
)
endfix
endfix
endfix
-
6. Re: IF("Gross Sales"==#missing) - not working
2625007 Jul 8, 2018 1:59 PM (in response to 2625007) -
7. Re: IF("Gross Sales"==#missing) - not working
Sidharda Chava Jul 9, 2018 7:17 AM (in response to 2625007)Hi As a first step can you try below code. This iwll ensure if the condition to check Gross sale = #missing or 0 is working or not.
FIX("Actual","FINAL", @RELATIVE("Total Departments",0))
"SGA Account"
(
IF( "SGA Account"->"Customer_NA"->"ProductTarget" <> #MISSING)
IF("Gross Sales"==#Missing or "gross sales"==0)
@return(@hspnumtostring("Gross Sales"),error);
ENDIF
ENDIF
)
-
8. Re: IF("Gross Sales"==#missing) - not working
user9928941 Jul 9, 2018 2:58 PM (in response to 2625007)Hi,
Per the doc you cannot use @CURRMBR on the left hand side of a formula. Fix on MSC-XXX and have it equal to @MEMBER(@CONCATENATE("P_",CONCATENATE(@SUBSTRING(@NAME(@CURRMBR(Product)),6),"0"))).
You could use a variable to create the required member name and just use @MEMBER(<P_Product>)->"SGA"->"Customer_NA"->"ProductTarget";
Regarding your latter code, when you say it doesn't work, is it because of validation error?
Thanks,
Pawan.