Traditional web-based reporting with SAS BI tools

wrs : using expression in amount

Reply
N/A
Posts: 0

wrs : using expression in amount

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
SAS Super FREQ
Posts: 8,814

Re: wrs : using expression in amount

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
SAS Employee
Posts: 238

Re: wrs : using expression in amount

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
Ask a Question
Discussion stats
  • 2 replies
  • 197 views
  • 0 likes
  • 3 in conversation