I want to know daily percentage in my table

[Srinivas]

Hi all,

I want to know everyday percentage metrics this application will be reloaded every day.see below screenshot

above are my metrics so those metric are everyday will increased, so i need how much percentage will increases everyday with another columns.If sales value increased 100 means 10% i want to see beside columns this is my query.

Can you please help me on this.

Advance Thanks

Munna

[sushil353]

Hi,

Using Above function you can achieve this:

(Sum(Sales)-alt(Above(Sum(Sales)),0))/ alt(Above(Sum(Sales)),1)

HTH

Sushil

[Srinivas]

Hi sushil,

Thanks for your fast response, Can you give me some more brief explanation, as per your above suggestion I have tried and  it's not working.

Advance Thanks

Munna