Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Max({<main_category={"Games"},launched={">=$(=yearstart(makedate(2016)))<$(=yearend(makedate(2016)))"}>} backers) -- result
but when i use
if(Max({<main_category={"Games"},launched={">=$(=yearstart(makedate(2016)))<$(=yearend(makedate(2016)))"}>} backers) = backers, name) --result
why can't I compare the maximum with the value in the column?
Try like:
Only(
{<
backers={`=Max(total {<main_category={"Games"},launched={">=$(=yearstart(makedate(2016)))<$(=yearend(makedate(2016)))"}>} backers)`
>}
backers
)
Note the backticks in red.