Vertical % on Dataview

Options
Maik Burghardt
Maik Burghardt Customer
First Anniversary Name Dropper Level 100: Foundations of Building in Board First Comment
in Platform

Hi,

can I somehow use vertical % ignoring subtotals on a dataview?

Thanks

Accepted Answer

  • Björn Reuber
    Björn Reuber Employee
    Community Captain First Answer First Anniversary 5 Up Votes
    Answer ✓
    Options

    Hello @Maik Burghardt

    all algorithm are "only" working in the most nested by row entity. So the vertical percentage is calulculated in reference to the first subtotal.

    A possible solution for your request is to use a simple nexel formal like =[@a;;]/[@a;;;Point.Total]*100 ,there are also other solutions, but in this case Nexel might be the easiest (and it is not dependent on cetain enitities in by row)

    image.png

    regards

    Björn

Answers

  • Samson Sunny
    Samson Sunny Employee
    First Anniversary April Badge of the Month Community Captain February Badge of the Month
    Options

    Hi @Maik Burghardt,

    You can use the "Hide Totals Row" in the dataview settings to hide the sub totals.

    image.png

  • Maik Burghardt
    Maik Burghardt Customer
    First Anniversary Name Dropper Level 100: Foundations of Building in Board First Comment
    Options

    I still want to see the subtotals but the calculation of the vertical % should exclude it

  • Bart Scott
    Bart Scott Active Partner
    5 Likes Photogenic Community Captain First Anniversary
    Options

    You could do a format on the Total/Sub Total line for that block using the same Font/Background color to Hide the total. But exporting to Excel that still may come thru. Or you can change how the total is calculated versus Summed to make it a meaningful value.

    Bart Scott

    CFO Solutions LLC

  • Shisong
    Shisong Active Partner
    First Answer 5 Likes First Comment Advocate
    Options

    Try to set summary as "Calculated".

    image.png

Categories