11 Replies Latest reply on Jul 14, 2017 12:56 AM by Rasmus Michelsen

    Calculated field --> count output

    Rasmus Michelsen

      I have made a calculated field, that returns a set of values.

      It works like this:

       

      IF X THEN '1'

      AND

      ELSEIF Y THEN '2'

      END

       

      It plots 1 and 2 correctly, but my problem is, that I can´t count the output. Somehow it isn´t registered as numbers, but text?

       

      When I try, it looks like this

       

                                    X |  1 |

                                    X |  1 |

                                    Y |  2 |

                                    X |  1 |

                                    Y |  2 |

                                    Y |  2 |

      --------------------------------

      Grand Total             |      |

       

      How can I make it see it as numbers, and return a '9' under Grand Total?