Try using column data formats or else use string functions as Mr. Gianni suggested.

convert it char and then validate.

How about Column's data format?

Use AnalysisGet Recipients from the Analysis Used in the Agent ConditionAnalysis Try to use user loginId in the report and use above option in Recipients tab if that works.

Try like below ( ($2-$1)*1.00)/$2

Can you try the same steps what you did in Pivot table without RSUM? I think you'll understand after that. If not helping! thank you for your time.

I mean to say SIGMA or aggregation as you pointed with RED arrow

If you are Summing again in Pivot which means no point of using RSUM.

I would suggest to do customization bits and pieces instead of whole at once. Error is at Line:2, Col:1874, Attribute 'boundingLayerID' is not declared for element 'container'

if you are still looking for solution then, try this. Just putting it simple once you get the data then you need to format the data as ##-##-#### using Data Format in short : msum(EndDate ,2)-EndDate in detail: MSUM((cast(replace((Cast(DayofMonth(EndDate) as char)||cast(Month(EndDate) as char)||cast(Year(EndDate) as…

I suspect on dummy column. can you share logical query for that? or else add where clause to that dummy column query by pulling any existing column like where existingColumn is not null

Just in case if you have EndDate Row_WID or EndDate in number format like DDMMYYYY or YYYYMMDD format then try this and later you may format it back to date format. The below is works for number datatypes only. msum(EndDate ,2)-EndDate

Just in case check this Doc ID 743555.1 Doc ID 531092.1 is may not be relevant but check once

Check this https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2556

Try this: Create/Edit Agent, Delivers tab-> Select Recipients-->Emails and then + sign for adding email

Check this guide Integrating Oracle BI Presentation Services into Corporate Environments Using HTTP and JavaScript

You need to use the formula something like below in the BMM layer TIMESTAMPDIFF(SQL_TSI_DAY,"Stage_InProgress_Start" , "Stage_Closed_Start")

I would suggest to change your approach to broader way, you may use CASE instead of FILTER.

Check your config based on https://docs.oracle.com/middleware/1221/biee/BIESG/deliversconfigset.htm#BIESG1372

Just in case you want to try with Foreign key joins in BMM Layer, try to enable it from Options. It's just suggesting you to give a try!