need to create a metric which generates a arithmetic progrssion

[arjunravi]

Hi,

I need to create a metric whic would gnerate values 0,5,10,15,20....100.I tried the running sum but the 1st value shud be 0.
Also need to create a metric whose values are 0,100,100,100...i.e 0 followed by 100 for the rst of the rows.


Any suggestions wud be helpful.


thanks

 

[Z3]

The running sum should be okay just need to minus 5 on all numbers. You 2nd request could be a CASE or If statement with a running sum compare to original metric if the same then 0 else 100.