This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Time Balance (Average)

April 3 2017 at 2:52 PM
No score for this post
RP 
from IP address 63.96.234.25

I have an account which is assigning a value of 1 or zero to everyone entity based on if that entity had sales. I have this account tagged as "TB Average" so that for the Month and YTD summaries, it reports an average of the weeks, however it appears to be reporting the balance of the last week in the month. Any suggestions on what the issue could be? I am using 11.1.1.3.

IF("Sales" == 0 OR "Sales" == #MISSING)
#MISSING;
ELSEIF(@ISATTRIBUTE("US Ecom"))
#MISSING;
ELSEIF(@ISMBR("Frame"))
#MISSING;
ELSEIF(@ISMBR("Merch"))
1;
ENDIF

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Skip #Missing - Cord123 on Apr 3, 2017, 3:11 PM
  2.  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.