6 Replies Latest reply on Feb 1, 2019 3:16 AM by Roger Pouly

    Going from regular format to percent difference with a parameter (changing the format in the calculated field) - Is this possible ?

    Roger Pouly
    Roger Pouly Jan 30, 2019 8:28 AM

      Good morning everyone, apoligize for the title.

       

      An interesting task I would like to do is to be able to switch the view from regular numbers to percent difference, from a parameter. My issue here is formating.

       

      Exemple here, when the parameter is set to value :

       

       

      When the parameter is set to % difference :

       

      What I would like to see is :

       

       

      Here is my formula :

       

      IF [Choosing view Parameter]="% diff" THEN (ZN([Number of sales]) - LOOKUP(ZN([Number of sales]), -1)) / ABS(LOOKUP(ZN([Number of sales]), -1)) ELSEIF [Choosing view Parameter]="Regular" THEN [Number of sales]

       

       

      Any hindsight ?

       

      Thank you

       

      Roger