Hi all,
I'm having a rare old time with a feature of Report Viewer, passing details from a SQL query via Oracle - these don't appear to be an issue as not other parts of my report are failing, however this line in a report viewer cell is causing no end of grief.
VARCONV is a total of 3 other fields and in one instance, which is prone to happen again, has returned 0 - causing the division against LIVE_NET_RETAINED to cause a divide by error, which should be fixed by the IIF statement, but isn't.
The full query is
and is used to work out the conversion commission against a quoted & sold product.
Thanks in advance.
Cheers,
Jon
The full query is
I'm having a rare old time with a feature of Report Viewer, passing details from a SQL query via Oracle - these don't appear to be an issue as not other parts of my report are failing, however this line in a report viewer cell is causing no end of grief.
Code:
=IIF(Fields!LIVE_NET_RETAINED.Value/Fields!VARCONV.Value <= 0,0,Fields!LIVE_NET_RETAINED.Value/Fields!VARCONV.Value)
VARCONV is a total of 3 other fields and in one instance, which is prone to happen again, has returned 0 - causing the division against LIVE_NET_RETAINED to cause a divide by error, which should be fixed by the IIF statement, but isn't.
The full query is
Code:
=IIF(SUM(Fields!LIVE_NET_RETAINED.Value)/((SUM(Fields!NTU_NET_RETAINED.Value)
+SUM(Fields!QUOTE_NET_RETAINED.Value)+SUM(Fields!LIVE_NET_RETAINED.Value)))=0,0,
SUM(Fields!LIVE_NET_RETAINED.Value)/(SUM(Fields!NTU_NET_RETAINED.Value)
+SUM(Fields!QUOTE_NET_RETAINED.Value)+SUM(Fields!LIVE_NET_RETAINED.Value)))
Thanks in advance.
Cheers,
Jon
The full query is