Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago
Solved

Filtered Calculation

Hi, I need to create a new calculation for my table to remove the values prior to current month.    The calculation will need to be something like this but not too sure on the correct syntax.   ...
Need Help
  • ThomasWeppler's avatar
    ThomasWeppler
    3 years ago

    Sorry I was a little fast it need to be sum(apps[app_amount])))

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
3 years ago

Try this
Name =

Calculate(sum(apps[app_amount),

if(SELECTEDVALUE(

Apps[info]) in {"test","live"} &&
SELECTEDVALUE(
month_index[month]) < today(),
0,
apps[app_amount]))

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
3 years ago

Thanks for the suggestion but unfortunately, the final part of the logic "apps[app_amount]))" isn't being accepted. I just have the red line underneath.