Forum Discussion

RustyShacklefor's avatar
RustyShacklefor
New Contributor III
3 years ago

QuickViews calculations

how can you add calculations into a quickview.  how can you add the input fields also? I seen both at splash so i know its possible 

  • ChristianW's avatar
    ChristianW
    3 years ago

    This should work in the Time Member Filter

    T#Root.List(2022M6, 2022M5),GetDataCell(T#2022M6 - T#2022M5):Name(Variance)

  • ChristianW's avatar
    ChristianW
    Valued Contributor

    Can you explain this a little more: "how can you add the input fields also?"

    You can use GetDataCell like in a cubeview:

    F#Root.List(NewHires, Terminations),GetDataCell(F#NewHires - F#Terminations):Name(Variance)

    • RustyShacklefor's avatar
      RustyShacklefor
      New Contributor III

      i just need a column for comments for each line that stays in the quickview

      • Cosimo's avatar
        Cosimo
        Contributor II

        Rusty, you can use V#Annotation (or any of the other View members that accepts text) to capture and view text on a quickview row. 

    • RustyShacklefor's avatar
      RustyShacklefor
      New Contributor III

      how do you add a column for a variance for the A#?  or does it have to be f#?

       

       

       

      • ChristianW's avatar
        ChristianW
        Valued Contributor

        This should work in the Time Member Filter

        T#Root.List(2022M6, 2022M5),GetDataCell(T#2022M6 - T#2022M5):Name(Variance)

    • RafMarques's avatar
      RafMarques
      New Contributor III

      Hi ChristianW ,

      Wondering if we can read Cell reference i.e. Member selection based on the cell for Year? or any other. T#cell1

      thx