Email Schedule when column captures negative value

[Former Member]

Hi,

I need to schedule an email to the client only when table populate with negative values.
for example: I have a one computed measure column and it displays only negative records according to the data refresh everyday at the backend. It doesn’t show negative numbers everyday. I want when that column gets negative number based on the data refresh (might be after couple of months, weeks or so on) only then it shoots an email to the client.

How can i get this? Any suggestions?
Thanks in advance!

[omkarsambare]

You will be able to schedule the report depending upon the recurrence you want but you wont be able to send specifically when the negative numbers are fetched.

-Omkar

[omkarsambare]

Hi Dia,

It is not ideally possible to send mail based on the values fetched in report as there is no way to automate it.

However you can check the BOBJ SDK to check if any script can be generated to achieve it.

-Omkar

[Former Member]

Thank you Omkar for quick response.
So basically i can schedule the report as it is based on weekly or daily. Any other way you can recommend?