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).
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.