Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, I am looking for this requirement ,
this requirement is a level 2 requirement , what i mean is after clicking on level 1 it will bring me to level2
so category and decision filed are selected at level1 based up on that selection the level 2 shows only those supplier which full fill thet category and decision values
level1 dimension:1)category
2)decision
expression
=count({$<MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)
level2 dimension:1)name1
2)decision
expression:1)=count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)
2) percentage expression
count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)
/count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1>PRUEFLOS)
i posted this requirement earlier , and some one had replied me with the above expression through which he is able to achieve my requirement as seen in below but when i tried using the same expression i am not getting the same out put
please find my attached test file
yes this is my requirement i need % between same name1 values ,same as shown in the screen short, i was using the same expression but unfortunately it is not working for me .
count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)
/count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1>PRUEFLOS)
Then again --> Looking at your screenshots, it looks like your expression is working.
Hello ,
Any suggestion for my requirement ,i have attaches the file