Forum Discussion

ajohn1's avatar
ajohn1
Icon for Advocate I rankAdvocate I
7 years ago

Table Sum is incorrect.

if I were to take out my first 'if' statement "(if(value1-value2 <= 0, 0,)" the value comes out to be -92. But I'm replacing its value with 0. So why is calculating with the -92.  
Need Help
ajohn1's avatar
ajohn1
Icon for Advocate I rankAdvocate I
7 years ago

We found a work around, by appending a duplicate of our time and some other magic. To much to explain at the moment.

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi ajohn1,

 

If you solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best  Regards,

Cherry

  • ajohn1's avatar
    ajohn1
    Icon for Advocate I rankAdvocate I
    7 years ago

    I really appreciate replys from the community but neither of them worked for me. I would hate for somone to think the solution is in this thread. To make myself clear, we didnt get the table to add up the right way, but we formatted it to where it would be easy for our customers to understand.

     

    Please close this thread if you can.