Simply want to take an incoming value of -12.34 and make it a positive 12.34
Simply want to take an incoming value of -12.34 and make it a positive 12.34
Hello PowerPI ,
I like your alias !
I believe you should be able to accomplish the value conversions e.g. by defining Convers as -1. Please refer to Transformations and scaling
Edit: Right after posting the above, I have read your question again and noticed that negative values wont work. I haven't tested myself. Can you indicate what combinations of Convers, TotalCode, SquareRoot and DZero you have tried?
If conversion through Transformation and scaling isn't working, you may find a way to do the conversion using PI Asset Framework.
Gregor.Beck, thank you for your reply.
I haven't tried anything else. I was looking over this table and didn't see anything relevant to try.
It's very common for to get a KW value from a transformer that is a negative value when a site is producing because the meter is looking at the value from the grid's perspective. We work from the site's perspective and want to see the value as positive when the site is producing power. It is a very common need for us and I was expecting the conversion would be more common than it apparently is.
This is the table I was trying to work from.
Do you have any suggestions of conversions to try?
Thanks
Hello PowerPI ,
based on my understanding of your use case, you should be able to use Convers = -1 with TotalCode = 2 and SquareRoot = 0. I found a case in our case database suggesting this too.
Sorry. My bad. I see that it complains but still works. I thought the yellow and warnings meant it wouldn't work.
Thanks for your help.
Glad it to see that it works for you PowerPI !
Lesson learned: Don't become tricked by PI SMT!