Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table as shown below
I am calculating Current - Dec = (Current Month POC - Last Year December month POC)
Eg: for January-2018, 28.30-19.90 = 8.4, for February-2018, 39.40-19.90 = 19.5.
But My Values are wrong as highlighted in the above image.
What is wrong with my expression here? Attached is the file for reference
Sum(POC) - Sum({<Num_Month = {'$(vPreYearLastMonth)'},Year = {'$(vPreYear)'}>}POC)
thanks
Bhavesh
thank you @sunny_talwar, please look into the attached file;
Try this
Sum(POC) - Above(TOTAL Sum(POC), Num(Month))
I think your values for Jan, Feb, Mar are not right.... they should be 0, 0, and 0, right because you have 100-100 for all three months of 2018
Awesome @sunny_talwar, thank you
-you are right, it was a typo error
@sunny_talwar the expression is null when selecting Month field, it is showing correct values when no month is selected.
Since, this post is closed Please look into the link below, thanks