QuickViews calculations

RustyShacklefor
New Contributor II

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 

1 ACCEPTED SOLUTION

This should work in the Time Member Filter

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

View solution in original post

8 REPLIES 8

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:

ChristianW_0-1657275168667.png

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

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

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. 

how do you add a column for a variance for the A#?  or does it have to be f#?RustyShacklefor_0-1657559130703.png

 

 

 

This should work in the Time Member Filter

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

that works.

 

thanks 

how about some kind of conditional formatting in a QV? is that possible? I would like to highlight the variance column's if there was a 10% swing or 10K fluctuation 

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