Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How can I calculate the diff between two products from different tables and with a set of conditions

I've got two different types of diesel, each of them with different prices. I've also got calculated Moving Averages of both, and I need to see the average GAP between them but under the condition t...
Need Help
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

try this?

 

GapAvg = 
IF(
    [Average A]<>BLANK() && [Average B]<>BLANK(),
    [Average A] - [Average B]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    EXACTLY THIS!!! 

     

    I've looking for this the whooooole day. I appreciate so much your help.

    • FreemanZ's avatar
      FreemanZ
      Icon for Super User rankSuper User
      3 years ago

      thank you as well. Not every suggestion is varified with real data by the advisor. So your timely feedback is extremely important.