Time Balance (Average)

Time Balance (Average)

Joined: April 3rd, 2017, 6:49 pm

April 3rd, 2017, 6:52 pm #1

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
Quote
Like
Share

Joined: January 11th, 2017, 9:26 pm

April 3rd, 2017, 7:11 pm #2

Do you have the option for Skip Missing selected? Also, what does your period dimension look like? You mentioned both Month and Week in your OP.
Quote
Like
Share


Confirmation of reply: