[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 VitaliThis 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