Hello,
I am trying to use the following IF statement as a calculated field in my pivot table. However, it only recognizes the first IF and rounds to the tenth decimal place as stated first.
=IF((Conf_pos/Scrn_acn)>=1,ROUND((Conf_pos/Scrn_acn),1),IF((AND(((Conf_pos/Scrn_acn)<1),((Conf_pos/Scrn_acn)>=0.0195))),ROUND((Conf_pos/Scrn_acn),2),ROUND((Conf_pos/Scrn_acn),3)))
Both "Conf_pos" and "Scrn_acn" are numeric variables in my pivot table.
Thank you!
Bookmarks