I have a table having fields A, B , C, D(codes), I have to create a graph thats shows the codes at x axis and expression which is ((A-C)/A*100) at y axis. The table has different records with same code.
What I want is if i click at any code the graph should calculate the formula for the records having same code.
I'm not sure I follow what your data structure is here. Are A,B,C,D fields or values within a field? If they are fields what values do they contain? Could you post up a snapshot of the table that you are working with and describe in more detail what the graph should show?
attached is the snapshot of table structure, what I want is if I click at a branch code in listbox it should calculate the formula which i have put in a expression.
i have design a straight table but it shows wrong results.
I'm not sure how the data model you have pictured maps on to the expression you gave in your initial post. It sounds like you need to put the branch code in as a dimension and then build your expression based on the numeric fields. What sum is it that you need to calculate based on the column names that you have pictured?
