hahah I think I tried to delete it and posted it elsewhere and it wouldn't delete from here

I did. They are looking into it. They don't believe its on their end but they are doing the work.

Thank you!

Yes I can however, I do not believe it is coming from Task Factory. This does not appear to be a vendor issue at first glance so trying to see...

Post Deleted

I am referencing the text boxes because the formulas are not easy to work with really. Was taking the easy way out. They aren't just a field in the dataset.

Yes there is...I generalized the formula with textbox 1 and 2 because the report was rerunning when I sent that message...Here is what it is:  so text box 2316 is...

So this was my formula that gave that error:

iif(cstr(ReportItems!Textbox1.Value)="-" or cstr(ReportItems!Textbox2.Value)="-","-",ReportItems!Textbox1.Value-ReportItems!Textbox2.Value)

Let me run it that way. I have been running it on the server because its quite a large report and takes a while.

[rsRuntimeErrorInExpression]...

I did not find a solution. I am not sure what happened yesterday but I was working and today, it is back to giving me #Error.

I think I found the error but I am not sure if there is an alternate solution. I have to change reach of the ReportItems! formulas to cstr(ReportItems!....)...kind of annoying....

You wouldn't think so but I am having issues. Makes no sense to me and that is why I think it is so obvious haha!:-D

I know floating is used for the data type for percent_rank(). I tried changing to something in a previous post but that didn't change the output at all.

I probably will have to find another way but I have hundreds of records and in some case thousand or more. I will check that out however.

Thank you for the information. I will look into that. In addition however, I noticed some percent_rank() values would only get to around 65% or so as the max. Something...

Thanks for the suggestion. I tried it but I got the same results. Any other suggestions?