Forum Discussion

jirazazabal's avatar
jirazazabal
Cloud Apps
08-11-2022

How to limit the values showed without altering values?

Hi, We have some scenarios when we need to calculate some metrics based on all the history. For example, contribution and more. We need to include several data to get the right value. But, for exam...
Dashboards & Reporting
harikm007's avatar
harikm007
Data Warehouse
08-11-2022

Can you share the formula you were trying and the actual calculation you need?

-Hari

jirazazabal's avatar
jirazazabal
Cloud Apps
08-11-2022

Two metrics:

YTDSum([Total Bin_Suscrip_Act_Instal (1)])

Contribution([Valor (1)])

 

  • harikm007's avatar
    harikm007
    Data Warehouse
    08-11-2022

    Here, instead of using 'Contribution' function, try calculating the contribution by using division operator:

    If the formula is 'Contribution(SUM([Valor (1)]))', change it to :

    SUM([Valor (1)])/(SUM([Valor (1)]), ALL([Date]))

    -Hari