sccardais

Set Variable to calculation based on Get Layout Object Attributes

Discussion created by sccardais on Jul 18, 2017
Latest reply on Jul 19, 2017 by sccardais

I have a cross tab layout that uses filtered portals to show record counts of Demos and Orders that fall between two dates.

 

The portals are based on a Self Join that matches on a Product ID (stored in a Global field in the parent) and the values in two date fields, Demo Date and Order Date. The counts shown below are correct but I also want to show a conversion rate for each column.

 

For example, the conversion rate for May-17 would be 33.87% (21/62)

 

I've named all of the data objects on the layout and confirmed in the Data Viewer that the objects can be used in calculations but I don't know how to store the results in variables to show the results for each column.

 

is there a way to do this or is there a better way to do this that doesn't involve naming objects?

 

Outcomes