Different Format in Master Items

[george55]

Hi all,

Have a Master measure x dividing by y. Want to show the result in percent. Have different behaviors on different diagrams:

Key indicator
Automatically the result is divided by 100 and displayed as %. e.g. 0.25%.

Line Chart
Result ist 0.25, when I format this in percent, logical result: 0.0025%

Why this different behavior? Any idea how to align to have 1 master with the same result? 

Thanks

[y_grynechko]

Hey,

can you share the master measure? 

[george55]

$(vW_Count_X) / $(vW_Count_Y)

Is this enough? or you need the hole datamodel and the formula behind the variables? not possible, sensitive data.

[y_grynechko]

What you provided is not enough. you just gave me X/Y. There is no need for you to publish data nor data model. Just share what is the cal behind the used variables.  Is it just count? or is there anything more happening in vW_Count_X and vW_Count_Y. 

[george55]

Count(If(Len(Trim(%RoleName))<>0, AUFGABEID))
/
    Count(If(FIELD1='Open Tasks'
AND
    Len(Trim(%RoleName))<>0
AND
    NetWorkDays(FIELD2, Today(), $(vHoliday))>2,
    NetWorkDays(FIELD2, Today(), $(vHoliday)))
)

[y_grynechko]

Hey,

thank you for that.

I created a master measure which is going to give a results from 0 to 1. After that drag and dropped it on KPI and Line Chart. Set the number format to be a %. This is the result: 

 

I was not able to re-create your issue with the information I got so I am not sure how to help. 

[george55]

Hi,

Thanks for trying to replicate. Can you show me what formating did you use? All Automatic?