Hi I have hopefully have a simple question I have a Chart with a straight table list of Projects, there is a field [Project Status] that can have a number of variables ,Initialized, Approved, started and Closed.
For my chart I’m only interested where the [Project Status] = ‘Approved’.
So I thought it was a simple case of adding “if([Projects Status]= 'Approved',1,0)”to the Calculation Condition.
But this only seems to work if first filter for “Approve using a list box etc., and then changing the properties to Detached, otherwise all I get is “Calculation condition unfulfilled”
What I want is for my Chart to only show Approved Projects without setting any filters.
What jsaradhi has replied, I already replied well before (Just check the reply time of all).... I have provided two different method of getting the end result.. Looks like you ignored my answer or may be never tested...
Calculation Condition in the General tab in an object properties window is to determine if the chart itself can be calculated or not. let's say you have a straight table and you do not want to calculate and display the results in that table unless the resulting rows are less than a certain number say 1000...or you want to calculate the table only when a certain selection is made, etc.
