Forum Discussion

TeresaSteeg1's avatar
TeresaSteeg1
Qrew Trainee
4 months ago

Gauge Report - Wrong Percentage

Hi! I'm creating a gauge report that shows the percentage of POs Invoiced/Current Project Budget (aka Percent Consumed).  This report is going on a dashboard that has a dynamic filter for Project Pr...
reports
TeresaSteeg1's avatar
TeresaSteeg1
Qrew Trainee
4 months ago

Here are the settings:

 

  • Mez's avatar
    Mez
    Qrew Cadet
    4 months ago

    What happens if you remove the nested 'if' statements, leaving just one If()? 

    If(

    [Project Priority] = "1", [Uni ... 1],

    [Project Priority] = "2", [Uni ... 2],

    [Project Priority] = "3", [Uni ... 3],

    [Uni ... All]

    )