Expression for my chart

[Anonymous]

Good afternoon gentlemen,

I'm here with some more questions.

I need to put an expression in my chart table that confront the values ​​of revenues in the previous month and the next month, and show me the value in%.

Attached is a picture explaining better.

I hope I have managed to get through my doubt.

Who can help me, thank you.

hugs

[#2]

You want to compare the revenue between two months?

Depending on how you have things set up, there are a few options.

A little more context would be helpful though, could you share a little more?

[MarcoWedel]

Hi Matheus,

one way would be like this:

=Num((amount-Below(amount))/Below(amount)*100, '0.00')

example qvw attached:

hope this helps

regards

Marco

[Anonymous]

Hi Marco,

Thanks for writing, I tried to run the expression above and did not work.

I'll try to explain it better.

The data in the field "amount" values ​​are not fixed, they are the results of the expression = sum (VL_TOTAL_NF_SAIDA).

Look at my qvw file:

Thanks for the help !

Matheus

[PradeepReddy · Accepted solution]

try the expression like this....

num((sum(VL_TOTAL_NF_SAIDA)-Below(sum(VL_TOTAL_NF_SAIDA)))/Below(sum(VL_TOTAL_NF_SAIDA))*100, '0.00')

[Anonymous]

Wow !

Now it worked !

Thanks !

[MarcoWedel]

sorry that my answer wasn't helpful.

regards

Marco

[Anonymous]

Marco,

Thanks for trying to help me.

Again thank you.

[MarcoWedel]

you're welcome

regards

Marco