Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to work out a % of a number in an expression and this just isnt working :-
count(if(len([Default Notice Date]>'0'),BP)/count(if(len([Registration Date]>'0'),BP)*100))
HI
Try like this
count(if(len([Default Notice Date]>'0'),BP))/count(total if(len([Registration Date]>'0'), BP))
hope it helps
HI
Try like this
count(if(len([Default Notice Date]>'0'),BP))/count(total if(len([Registration Date]>'0'), BP))
hope it helps