Creating Report in Web Intelligence:
Need Report to show the same field(object) with different outcomes in the same report. Example: DBA has 12, 13, 14, 15, 16, 17, 18, etc…
Need report to show Gross Value associated with each DBA"
DBA12… DBA13… DBA 14… DBA 15
2.00…1.30… 1.34… 5.50
Tried this formula in Crystal Report but could not get but the first row to populate. Tried also in Web Intelligence same results. I currently do not have access to the Universes… I tried to run the formula below for each column but only ran the DBA number that was need for that column, still could not get the second, third, etc,… columns to populate
if {F0719.Y$PDBA} in [12,13,14,15] then {F0719.Y$RTAM}/100
else 0
kwright770 (BOB member since 2014-07-23)