Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thanks, I tried that but unfortunately it gave me back a result of 100% . I have included the full formula below Sum(DISTINCT CASE WHEN "- Participant Prospect Current"."Prospect Creation Date C" >= TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) AND "-…
-
Basically, my results come back like this using the formulas Current ... Previous 863 514 284 165 1698 1152 What i want to do is calculate the percentage difference between the results now. But when i do, i just get 1 or 100% back as a result when i try my using my theory in the above thread Many thanks Ashley