IF Statement

[#1]

Would anyone be able to shed some light on the following expression. Its giving me a blank field on my Pivot Table. Is it a syntax error or something?

if

((

(

Many thanks

Patient Id = '1000402' and Date = '09-11-2010' , sum(ReportingFee) = '15.00', sum(ReportingFee))

[boorgura · Accepted solution]

Please try this:

if([Patient Id] = '1000402' and Date = '09-11-2010' , '15.00', sum(ReportingFee))

[#3]

works fine now, thanks for that!