You searched for the word(s): 12
-
I don't know why the export to Excel would do that.
-
Also, you can click on details and send us the error message. :)
-
Add a field to your data source that is not in your view. Add a rule on open (tools->form options->general->rules) that sets the value on open but only if the condition that the field is blank is true. Promote this value to SharePoint.
-
Hi Zhen,
Yes, you cannot export secondary data sources. I suggest copying the contents into the main data source and then exporting. You could also just treat it as a separate document type in DBXL and report on it that way.
Best,
-
Nevermind tried it just turns the div to the symbol anyways. It displays a number but not a correct one. using two values of 2 and 4 it tells me the average is 1 instead of 3, still stumped.
-
I tried that but I think I have the syntax wrong or it doesn't work. Tried Round(Sumsection / 12) do I need to use the "div" instead of the divide symbol?
-
What if you round the average?
round(sumsection div 12)
-
Well I could but then I wouldn't have the average, need it to average then round in the same expression.
-
How about using the round() function? :-)
-
I have several fields summed and sent to a field called SumSection. I have a AverageScore field that is a text box that I want to average the result of the SumSection field. I can do the average fine by using (Sumsection) / 12, twelve being the number of fields. But how do I round the result? I just can't figure out how to string together then ...