I have been searching for a solution and have found lots of answers but not the one I needed. I am posting this because I think it resolves my issue but I'm not sure if I will have repercussions from this method. Please respond.
In CR9 Crosstabs I am trying to create a % field based on the differece between two other fields. Example :
Billed Allowed Saved %Saved
T1 41,674.68 21,455.68 20,219.00 49%
T2 1,593,064.99 791,927.93 801,137.06 50%
(this lines up fine on entry but when viewed it loses alignment)
Everything I have read so far says Crystal cant do the %Saved because it wont allow you to create a formula with a formula etc... Saved and %Saved are formulas - Saved takes the diff between billed and allowed and %Saved usually refers to Saved and divides by billed. Since I cant reference a formula within a formula in crosstabs, I duplicated the syntax in Saved for the %Saved field then added the division
When I added this field in the Summarized area in Crosstab Expert I changed from default SUM to Weighted Avg with table.total_charges.
So far I am getting an accurate % of the difference.
Everything I have read says I cant do this, that I have to create a manual crosstab (which I can't do because of dynamics).
This was so simple I am afraid I am missing something. Will my percents be off someday? Is this an accurate solution?
If this is a good solution how can I get this on the other threads or in FAQ or the BO Crystal Decisions site for that matter, so that others can see it?
In CR9 Crosstabs I am trying to create a % field based on the differece between two other fields. Example :
Billed Allowed Saved %Saved
T1 41,674.68 21,455.68 20,219.00 49%
T2 1,593,064.99 791,927.93 801,137.06 50%
(this lines up fine on entry but when viewed it loses alignment)
Everything I have read so far says Crystal cant do the %Saved because it wont allow you to create a formula with a formula etc... Saved and %Saved are formulas - Saved takes the diff between billed and allowed and %Saved usually refers to Saved and divides by billed. Since I cant reference a formula within a formula in crosstabs, I duplicated the syntax in Saved for the %Saved field then added the division
Code:
(({table.total_charges}-{table.REPRICED_AMOUNT})/{table.total_charges})*100
So far I am getting an accurate % of the difference.
Everything I have read says I cant do this, that I have to create a manual crosstab (which I can't do because of dynamics).
This was so simple I am afraid I am missing something. Will my percents be off someday? Is this an accurate solution?
If this is a good solution how can I get this on the other threads or in FAQ or the BO Crystal Decisions site for that matter, so that others can see it?