percentage calculation in UI

[pawwy1415]

Hi Experts,

Can any one please help me to calculate the below expected output column in UI

From Proftloss dimension need to calculate the percentageprofitloss

Logic is percentageprofitloss is aggregated by Deskid and date.

here 5.7 is claulated as

=(profitloss/deskid,asofdate aggregated total profit loss)*100

=(3.15/(0+3.15+0-58.45))*100

=5.7

when ever profit loss is null then it need to display 0

Please help me to calculate the above expression.

Thanks in advance.

[sunny_talwar]

May be this

Sum(profitloss)/Sum(TOTAL <Deskid> profitloss)

[sunny_talwar · Accepted solution]

What did you get? the values you shared? Use percentage as formatting or multiply by 100

Sum(profitloss)/Sum(TOTAL <Deskid> profitloss) * 100

[pawwy1415]

Hi Sunny,

The above expression is working fine in Straight table with multiple dimensions.

But when I have used the same expression in Line chart with Date dimension getting 100 for all the dates even by fliting the other dimensions also its not changing.

Could you please help me on this.

Thanks in advance.

[sunny_talwar]

Sure, would you be able to share a sample to show the issue?