Hi All,
Below is the function being used in report.
CASE WHEN sum ("product sales information". "Sales amount" by "master calendar". "Years description") is NULL THEN 0 WHEN sum ("product sales information". "Sales amount" by "master calendar". "Date of description ") <= 0 THEN 0 ELSE CASE WHEN sum (" product sales information "." sales amount "by" product master "." product name "," master calendar "." years description ") is NULL THEN 0 ELSE 100 * sum ("product sales information". "sales amount" by "product master". "product name", "master calendar". "years description") / sum ("product sales information". "sales amount "by" master calendar "." years description ") END END
I am trying to create aggregate measure in RPD and use that in report. The above function works fine when I use that in report but when I tried to create a measure in RPD its giving syntax error.
Can anyone please help me to create the measure in RPD? Is there any change of syntax for sum by function if we use in RPD?
Thanks
Krishna