Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Removing -100% from a calculation

Hi all,   I have made a calculation where I want to see the how much the average amount of transport delays per customer correspond with the average amount of transport delays. I am the displaying ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I solved it now. I created a second measurement that looked at my initial measurement and said "if the first measurement is -100%, then blank, otherwise show first measurement".

    IF(measurement1=-1,"",measurement1)

     

sg123's avatar
sg123
Frequent Visitor
5 years ago

I might be missing something, but can you just set up a flag to identify the -100% customers and then filter to exclude those?  Then do the calculations you need for the remaining customers?   Or set the -100% ones to 0, so they don't effect your calculation?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi! I want to keep the customers in the table (since I have more columns that are relevant for other things) so I don't want to filter out and exlude those.

     

    The second proposal, set the -100% to 0 - can you elaborate on that one? Thanks in advance! 

     

    EDIT: To clarify, the -100% (or any of the %) is not in a certain cell in a column, it's an aggretation of many different lines from the same customer since it's a distinctcount.