Focal Point
[CLOSED] Using same value in first sort for 2nd sort and calculate

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1767063416

December 15, 2011, 02:01 PM
BobV
[CLOSED] Using same value in first sort for 2nd sort and calculate
Hi all,
don't know how to phrase my title or search for this. Here's what I would like to do:
Use the same record count from one value in a sort to calculate results from a percent field that is the actual percent for each sort value. It's basically a lift over control in marketing. Here's an example:

Group # Prospects # Resp %Resp
Dir Mail 10000 1000 10%
Control 5000 50 1%


I want all those fields plus a field that has the direct mail prospects of 10000 for both direct mail and control and the calculate the response using actual % Resp. So additional fields would be:

Group What-If # Resp
Prospects (using actual % resp)
Direct Mail 10000 1000
Control 10000 100

Thought I could figure this out if possible. I've never used FML, so I don't think that's an option if that's the only way.

Thanks all.

Bob Vitali

This message has been edited. Last edited by: Kerry,


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8
December 22, 2011, 11:21 AM
Kerry
Hi Bob,

Has this issue been resolved? If not, per our technicals' suggestion, please open a case with Customer Support Services. You may call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
January 05, 2012, 03:23 PM
BobV
Kerry,
sorry for the late reply. Did not figure out. I will look into opening a case.


WF (App Studio) 8.2.01m / Windows
Mainframe FOCUS 8