Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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?
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
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
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')
Wow !
Now it worked !
Thanks !
sorry that my answer wasn't helpful.
regards
Marco
Marco,
Thanks for trying to help me.
Again thank you.
you're welcome
regards
Marco