dynamic item calculated value for "Value" column with percentage column(value/percentage)

[Naveen Tibco]

Hello,

i try to calculate value for"value" column and percentage columns. in text area dynamic items >>Calculated value.

sample Data:

 

 

 

 

Country

value

Percentage

Value/Percentage

 

 

USA

12

23%

52.17391304

 

 

UK

19

43%

44.18604651

 

 

india

53

60%

88.33333333

 

 

 

how to get calculated value for value column with percentage column.

 

calculated value = [value] / [Percentage]

pelase find the attachment for reference....

 

Thanks & Regards

Naveen

[Andrew Berridge]

Hi there,

Sorry - this isn't clear. What exactly are you trying to achieve How should the calculated value be aggregated across the data table Do you want it to produce a single value for all rows Can you explain it a different way

Thanks,

Andrew Berridge (TIBCO Data Science)

View my book on Spotfire!

[Naveen Tibco]

In my requirement I have "Value" column and "percentage" columns as above mentioned example data... i would like to calculated value in text area, result would be calculated value =  [value] / [percentage]ThanksNaveen 

[Andrew Berridge]

Hi Naveen,

You can only show a single calculated value at a time in a text area - if you wanted a value for each country then you could use a calculated value but restrict the data (in that calculated value - see the Data properties for the calculated value) to each country in turn. If you're trying to display a sort of custom table thing, then calculated values in text areas are not the right way to go.

If you want a single value for the entire data table, then you need to decide how you will aggregate the whole table up to a single value.

Andrew

[Andrew Berridge]

Actually my response above could be a bit confusing. A single calculated value item in a text area can only show a single value. You can have multiple calculated value items in a text area, but each must be configured to show a single value. Just for clarification!