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

      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