Category
Data Sources
Error retrieving results when using Calculations only
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.
The same question
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
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
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
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
Hi Ruth,
Glad to hear you figured it out!
Regards,
Nathan
Hi Ruth,
Glad to hear you figured it out!
Regards,
Nathan
Replies have been locked on this page!