Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I created a expression as shown below to get YTD percentage.
count (if([Completed on Time]='Yes',[Completed on Time]))/count([Completed on Time])
If I select a month, YTD percentage should not be changed (static).
Any help is greatly appreciated.
Thank You
Muralidhar
Count({<Month=>}if([Completed on Time]='Yes',[Completed on Time]))/Count({<Month=>}[Completed on Time])
OR
Count({<[Completed on Time]={'Yes'},Month=>}[Completed on Time])/Count({<Month=>}[Completed on Time])
Count({<Month=>}if([Completed on Time]='Yes',[Completed on Time]))/Count({<Month=>}[Completed on Time])
OR
Count({<[Completed on Time]={'Yes'},Month=>}[Completed on Time])/Count({<Month=>}[Completed on Time])
Thanks much BrunPierre!