Forum Discussion

Helper II

5 years ago

Solved

Help division error

Hi All, I am trying to divide two text columns for a particluar dimension. So i get error when the numerator or denominator has blank value. I went forward and added if clause as below but i stil...

5 years ago

pmadam Maybe:

XY =
IF(
  ISBLANK([DSAM Amount]) && Not(ISBLANK(VALUE([Customer Target]))), 
  0 ,
  [Customer Target] / [DSAM Amount]
)

Helper II

5 years ago

Hi Greg_Deckler ,

I get error. These measures are in text because when i added comma seperator, the measures were converted to type int to text.

dedelman_clng
Community Champion
5 years ago
pmadam you have the wrong syntax for DIVIDE:

Greg_Deckler 's code: XY =DIVIDE( [Customer Target], [DSAM Amount], 0 )

Your code: XY =DIVIDE( [Customer Target] / [DSAM Amount] ,0 ).

Even if you didn't throw an error with one of your "numbers" being empty, you are dividing by 0.

Hope this helps

David
Anonymous
Not applicable
5 years ago
pmadam

Why are you outputting numbers as text? This is not how you do stuff correctly. If you want to format a number in a visual, please use the formatting options in the ribbon, not the FORMAT function.
Pragati11
Super User
5 years ago
Hi pmadam ,

Are bot of your columns numeric which you are trying to divide.

DIVIDE is function that works on non-text values. If you think logically, how can you divide a text value by a numeric value.

Try modifying data type of your text column used in DIVIDE function to Numeric.

Thanks,

Pragati

Community Champion

5 years ago

pmadam Maybe:

XY =
IF(
  ISBLANK([DSAM Amount]) && Not(ISBLANK(VALUE([Customer Target]))), 
  0 ,
  [Customer Target] / [DSAM Amount]
)

amitchandak
Super User
5 years ago
pmadam , Your measure should be divide( [Customer Target],[DSAM Amount],0)

Related content