Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
my requiremnt is to show % of each decision filed value of same supplier ,to achieve this in a bar chart
i took dimension: 1)name1 //(supplier name filed)
2)decision //(accepted,rejected,exception)
and expression i wrote is:
count({$<YEAR= , Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS)
/count({$<YEAR=,Quarter=, ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1> PRUEFLOS)
so problem is while i am showing all the supplier i am getting different values
but if i choose one supplier then i am able to get what i am looking
this is what i am looking ,so i think i need to do a changes in my expression ,any one suggest me what changes should i need to do plz
i am getting these values when i unchecked relative option
Go to numbers tab and select Fixed to 2 and Show as percent
HI
i am getting ,these values when i unchecked relative option
WORKING, but a small problem is if i select a value from decision filed it should show its respective % only ,but now it showing me 100%,what i mean is
suppose JAY GANESH CHEMICAL: accepted :94.12%
rejected :2.94%
exception :2.94%
i am getting these values when i choose only name1,material name fields ,but if i chose decision filed then i am getting these
i think there should be a small change in the expression,so that on clicking decision filed it should show its respective % only, am i right
its showing the right values simply select the show in percent option in number tab it will work
Hi naveen,
look at the 'Number' tab and mark the check boxes same as in the picture below
HI,
WORKING, but a small problem is if i select a value from decision filed it should show its respective % only ,but now it showing me 100%,what i mean is
suppose JAY GANESH CHEMICAL: accepted :94.12%
rejected :2.94%
exception :2.94%
i am getting these values when i choose only name1,material name fields ,but if i chose decision filed then i am getting these
i think there should be a small change in the expression,so that on clicking decision filed it should show its respective % only, am i right
What is your current expression? Can you copy paste it from your application? The reason I ask this is because, I don't see the same issue when I click into a particular supplier
count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} PRUEFLOS)
/count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1> PRUEFLOS)