2 Replies Latest reply on Jul 12, 2018 2:12 PM by Riaz Khan

Hiding percentages on null values

Hello

I have four columns. In the first column is a running sum that takes data and does running total. The formula is

Current Week DN Drop

IF([Rptg Rolling Week]) = 0

THEN

[DN Drop Qty]

END

It shows data for every day, but there is no actual quantity in Thu-Sat so the number 595 repeats itself. In the second column I wanted the blank ones removed so I used this calculation

Current Week DN Drop - Nulls

IF NOT ISNULL(SUM([Current Week DN Drop]))

THEN RUNNING_SUM(SUM([Current Week DN Drop]))

END

Now I am trying to get the last column to show the percentage but not show the ones that should be blank like column 2 for Thu-Sat. So the 58.47% should only show for Wed and everything after that would be blank. The formula I am using is

% difference

(RUNNING_SUM(SUM([Current Week DN Drop])) / [MAX Current Week Forecast])

I thought fixing this would be as simple as changing out Current Week DN Drop with Current Week DN Drop - Nulls so

(RUNNING_SUM(SUM([Current Week DN Drop - Nulls])) / [MAX Current Week Forecast])

but it's not working.

Any help would be appreciated and thanks in advance.

• 1. Re: Hiding percentages on null values

Hi, try:

(IF NOT ISNULL(SUM([Current Week DN Drop]))

THEN RUNNING_SUM(SUM([Current Week DN Drop]))

END) /

[MAX Current Week Forecast]

1 of 1 people found this helpful
• 2. Re: Hiding percentages on null values

Thanks Joy! This worked perfect

Thanks for taking the time to answer my question!