Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I need to put in a KPI that is working out the % of a total amount of Customers but I need to use a sum if to select a fixed variable.
The formula I have so far is as follows:
sum(if([No. of Insertions]=1,(Customers)))/sum(if([No. of Insertions]=1,(Total Customers)))
I am getting the error of : ')' Expected, but no matter where I try and put brackets, it doesn't seem to like the 'Total' being in there
Can anyone help?
Thank you
Try this
Sum({<[No. of Insertions] = {1}>} Customers)/Sum(TOTAL {<[No. of Insertions] = {1}>} Customers)