Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Naveen Tibco

Recommended Posts

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...