AnsweredAssumed Answered

Newbie Help with if function

Question asked by DaveParry on Apr 28, 2009
Latest reply on Apr 28, 2009 by philmodjunk

Title

Newbie Help with if function

Post

I have a table that has a field called "from" and another field called "value" which has a monetory value, I want to have a total value for (say) leaflets after a specific date. These are to be displayed on another layout which I have associated with the table. 

I have created a calculation field (leaflet) with "If (From="leaflet" and Date >4/4/2009; Value ; 0 )" and a summary field (sum leaflet) with "total of leaflet".

It dosent calculate correctly and seems to sum all the leaflets regardless of date.

Its probably something stupidly simple but I cannot see what.

 

Outcomes