2 Replies Latest reply on Sep 5, 2018 8:56 AM by Lauren Brown

# Calculation to change measure value

I have a workbook already created and I simply need to know what calculation I need in order to change one measure.

I unfortunately cannot access the data source as it was a custom one a team member created so for time sake I need a quick fix.  The measure value I am trying to change is \$0.00 and it should be a dollar amount of \$2,048.

I need to know what calculation would place that in there in the interim, until the data source can be updated to calculate the right amount.

• ###### 1. Re: Calculation to change measure value

hi Lauren,

So if I understand correctly...

If you wish to change a "row" in the data then

IF [Sales in Dollar] = 0 THEN 2048 ELSE [Sales in Dollar] END

If it's an aggregated result (say a sum) which you want change then

IF SUM([Sales in Dollar]) = 0 THEN MIN(2048) ELSE SUM([Sales in Dollar]) END

should do the trick

2 of 2 people found this helpful
• ###### 2. Re: Calculation to change measure value

Thank you so much, that did the trick!!!