Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to calculate variance for max - min date
below is the format of my table
Emp date Amount
XXXX 12/31/19 250000
XXXX 09/30/19 350000
XXXX 12/31/19 450000
XXXX 09/30/19 650000
I want to calculate the variance between max and min
I have done as below format
(sum({<date = {'$=max(date)'}>}Amount) - sum({<date = {'$=min(date)'}>}Amount)) / sum({<date = {'$=min(date)'}>}Amount)
I am not getting the value after I did like this
someone please help me on this
Try like:
(Sum({<date = {'$(=date(max(date)))'}>}Amount) - sum({<date = {'$(=date(min(date)))'}>}Amount)) / sum({<date = {'$(=date(min(date)))'}>}Amount)
Hi,
I am still facing the same problem I am not getting the ouput
Could you share a sample or screenshot showing the issue? Else try to add more details to your problem statement like - where, how, ...