Forum

This content is now out of date.

Visit Our Community

Sequence Number

Hi,

Is there a way to get sequence number starting from �8000001� in my report at runtime

Thanks,

Suneetha
Suneetha,

Thank you for submitting your question to our forum.

Is it possible to get some clarification? By sequence number
do you mean the report ID number?

Please let me know and I will follow up accordingly.

Regards,

Kyle

Hi Kyle,

I meant Sequence number which is similar to Serial Number, instead of starting from 1 number should start from 8000001. Using the Analytical function,Accumulative Total I do not get the correct results.

Thanks,

Suneetha
Hi Suneetha,

if I have understood you correctly, I think you need 2 calculated fields, the 1st one simply has the value of 1. Drag this into the report and apply an "Accumulative Total" Advanced Function to it so that the resulting rows are 1, 2, 3, 4 etc.

Then the 2nd calculated field should simply have a valued of 8000001. Drag this into the report and apply the Advanced Function called "Sum of Columns" to it and then point it to the 1st calculated field. Then you will get 8000001 + 1, 8000001 + 2, 8000001 + 3, etc.


Forum image


Please let us know if that's what you were looking for or not.

regards,
Dave
Thanks Dave. That works :-)

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.