Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper 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
Impactful 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
    Helper 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. 

    • ThomasWeppler's avatar
      ThomasWeppler
      Impactful Individual
      3 years ago

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

      • M_SBS_6's avatar
        M_SBS_6
        Helper V
        3 years ago

        Thanks for your help