how create a calculated dimension

[#1]

Actually we have to create a calculated dimension in that list box.in our database there are 2 diff. fields namely "Invoice Quantity" and "Contract Quantity" in two diff. tables.we want to show the calculated dimension (Contract Quantity - sum(Invoice Quantity) ) as "Contract Status" so that it can work on individual item seperately.and we also want to asign two values in the list box "Contract Status" namely "PENDING"(if "Contract Status">0) else "COMPLETED".

[renjithpl]

Hi,

Just try in your load script something like this,

Load

*,

If(([Contract Quantity]-Sum([Invioce Quantity]) >0, 'PENDING', 'COMPLETED') as [Contract Status]

From

.......abc.QVD

Please let me know if this is not what you are looking for.

Regards

Ranjit

[#3]

Hi itsouvik.

You already have the answer.

In the dimensions tab you can find the Add Calculated Dimension button.

In the text box just enter:

=IF([Contract Status]>0, 'PENDING', 'COMPLETED')

Hope this help.

Regards