Forum Discussion

CESARPULIDOGDL's avatar
CESARPULIDOGDL
Helper I
2 years ago
Solved

ISSUE WITH DIVIDE -1

HI EVERYBODY

 

I HAVE A ISSUE, WHEN I USE A MEASURE THAT DIVIDE MONTH EXPENSE VS MONTH EXPENSE PREVIOUS YEAR & USE -1, THE VISUAL, HAVE A ISSUE THAT SHOW ME OTHERS YEARS THAT I HAVENT SELECTED IN THE SLICER DATE.

 

IN THE IMAGE, I CAN EXPLAIN BETTER, THE QUESTION IS HOW CAN I USE DE -1 AND DONT LOSS THE SLICER DATE.

 

REGARDS

 

 

Need Help
  • Anand24's avatar
    Anand24
    2 years ago

    CESARPULIDOGDL ,
    The issue seems to be that some results are evaluating to -1 instead of blank.
    Try the below measure:

    #med gasto promedio AAvsYTD = 
    IF ( 
    ([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1 = -1,
    BLANK(),
    ([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1
    )

     

3 Replies

  • Anand24's avatar
    Anand24
    Super User
    2 years ago

    CESARPULIDOGDL ,
    The issue seems to be that some results are evaluating to -1 instead of blank.
    Try the below measure:

    #med gasto promedio AAvsYTD = 
    IF ( 
    ([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1 = -1,
    BLANK(),
    ([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1
    )