How to do conditional count in BI Publisher

83 Views Asked by At

Assume in Status column their has values present, absent. I want to count how many present or how many absent has their. In Bi publisher(rtf) How can we do that ? Whats the code I need to write in MS Word ? I tried some code like <?if:Status='Present'>Count of 'Present': <?count(current-group()/Status[@value='Present'])?><?end if?> but it don't work. gives error. enter image description here enter image description here

1

There are 1 best solutions below

0
EdHayes3 On

You have

<?if:Status='Present'>

Should be

<?if:Status='Present'?>