Forum Discussion

bedot's avatar
bedot
Frequent Visitor
8 years ago

Subtraction between 2 column summarised differently

Hi all, I'm simply looking for a difference between two columns in a table which has the figures summarised different - column A is set to "Don't Summarize" (Freq Number) and Column B is set to "Cou...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi bedot,

 

If you can please share sampel data with expected result to help us clarify your requirement and coding formula.

 

Regards,

Xiaoxin Sheng

bedot's avatar
bedot
Frequent Visitor
8 years ago

Hi Xiaoxin,

 

 

Would the above be enough detail? "Freq Number" = a look up based on today's date. E.g. Monthly today would be 7 now - where as "Count Actual Items" = a count of items we've actually recieved. The expected result is "Difference" highlighted in yellow, whcih clulates the difference between the two columns

 

THanks

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi bedot,

     

    I'd like to know the calculate formula about freq number and the sample data about client.

     

    Regards,

    Xiaoxin Sheng