Error retrieving results when using Calculations only

Ruth shared this question 2 years ago
Answered

Whenever l use a calculation that involves (/) l cannot retrieve the results on my report although the (Prepare) shows the correct values for the same formulae.

Comments (3)

photo
1

Hi Ruth,

The best way to tell what is going wrong here is to look at the logs. Can you zip and send me your entire Yellowfin logs folder?

youryfinstallation/appserver/logs

Regards,

Nathan

photo
1

Hi Nathan


l later realised that in my calculations, there was a case when the denominator would be zero and hence result undefined. l put a case for this condition as follows and it worked.


CASE WHEN NetAmtLoc - Comm - Fee != 0 THEN ( ( Comm * -1 ) / ( NetAmtLoc - Comm - Fee ) ) ELSE 0 END


Regards,


Ruth

photo
1

Hi Ruth,

Glad to hear you figured it out!

Regards,

Nathan