Some customer exit variable not consistently displaying correct output

[former_member1051071]

Hi,

In my query I have 4 customer exit variables which calculate Q1 thru Q4 totals. I also have customer exit variable which calculates YTD.

Problem is that if I refresh my query in Analyzer, all the Q1 thru Q4 are blank, but YTD is correct.

If I re-open the query and execute, then the Q1 - Q4 data is displayed correctly.

RSRT displays correctly all the time.

The only difference I can see is that YTD variable is set as "Selection Option" and the Q1 - Q4 are defined as "Interval'.

Any suggestions?

[Former Member · Accepted solution]

Click the (Office Button) In excel and choose (Excel options). Under the (formulas) tab there is an option for (workbook) calculation, make sure (automatic) is chosen...

see if that helps

[former_member1051071]

The cmod (customer ext) variables were not coded correctly. Need to specify the "vnam=" when reading the variable table, not just the "iobjnm=".