B
boothkd
I am having trouble with an IF function call in the formula of
calculated field in a pivot table.
The pivot table has a calculated field called 'SDLT Tapes Required
containing the following formula:
=IF('Backup Media Type'="SDLT",'Total Backup Capacit
Requirement'/220,0)
where 'Backup Media Type' and 'Total Backup Capacity' are fields in th
pivot table. 'Backup Media Type' contains text values such as "SDLT
and "DLT 20/40".
The field always displays a result of 0 even though there are rows i
which the 'Backup Media Type' is "SDLT".
I have other calculated fields in the same pivot table with formula
using the IF function successfully but they use numeric comparison
instead of string comparisons.
Any ideas or suggestions
calculated field in a pivot table.
The pivot table has a calculated field called 'SDLT Tapes Required
containing the following formula:
=IF('Backup Media Type'="SDLT",'Total Backup Capacit
Requirement'/220,0)
where 'Backup Media Type' and 'Total Backup Capacity' are fields in th
pivot table. 'Backup Media Type' contains text values such as "SDLT
and "DLT 20/40".
The field always displays a result of 0 even though there are rows i
which the 'Backup Media Type' is "SDLT".
I have other calculated fields in the same pivot table with formula
using the IF function successfully but they use numeric comparison
instead of string comparisons.
Any ideas or suggestions