Logical operator in Calculated Field Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
why wouldn't such a formula checking the value of field named "H" to sum
field named "Shop" work?

=(H<>0)*Shop

can't we use logical operators in calculated field formulas?

Thanx,
Fatih
 
The formula works: if H <>0, you will get value of SHOP, otherwise 0.

What result do you get / expect to get?
 
Let me be more specific:

My data base is:

Sysyem H Shop
100 2 100
200 2 100
100 2 100
200 0 100

My Pivot Table yields following results

Row Labels Sum of Field1
100 200
200 200
Grand Total 400

formula in calculated field Field1 is : = (H<>0)*Shop

Where as for system 200 sum of Field1 must be 100
 
Back
Top