wrs : using expression in amount

[deleted_user]

Hi,

in WRS, I try 'd like to make amount in cross-tabulation. One variable (C) is a composed variable : C= a/B defined in Info Map.
My problem is that for C variable, i don't want to have the sum in the amount but to realize the expression that compose the variable (A/B).
I have modified the aggregations properties in Info map but in WRS, i still have then sum like result and not then expression (A/B).

Thanks for your help

Nolwenn

[Cynthia_sas]

Hi:
This doesn't seem like a stored process question. Your best bet for a response that focuses on Information Maps and WRS would be to contact Tech Support.

cynthia

[AngelaHall]

Have you tried to create a custom measure within the Web Report Studio report itself? I have a feeling that the difference between running it query time (information map) and running it post time (web report studio) is causing a hiccup in the ratio.

Go to Select Data and choose Custom to create a custom measure. There are screenshots of this within my paper : http://www2.sas.com/proceedings/forum2008/194-2008.pdf on pg 12.

Then attempt to use this custom measure in your cross-tab.

Angela Hall
Zencos Consulting
http://www.zencos.com