Use of Variable in Set

[sagar_vij99]

Hi I am trying to showcase numbers in a text object using Set.

Here is my expression

=({$<P_Month={"$(=Date(Addmonths(Month_Name,-1),'MMMM'))"}>}$(TPH))

now TPH is a variable. Its definition : num((($(Pro_T)+$(Qct))/$(Avt))*100,'##.00')

Again explanation of each variable is :

Pro_t: num(sum(Processing_Time)/60,'##.00')

Qct: num(sum(QC_Time)/60,'##.00')

Avt: num((sum(Attendance))*7.5*.89,'##.00')

I need to calculate the result for last month for which set is there.

I cant make it work using different logics. please assist me here to get a solution.

Regards

Sagar

[Anil_Babu_Samineni]

Try this as full expression

=Count({$<P_Month={"$(=Date(Addmonths(Month_Name,-1),'MMMM'))"}>}

((num(Sum(Aggr(sum(Processing_Time),Month_Name))/60,'##.00') + num(Sum(Aggr(sum(QC_Time), Month_Name))/60,'##.00'))

/ num((Sum(Aggr(sum(Attendance), Month_Name)))*7.5*.89,'##.00'))*100)

[Anil_Babu_Samineni]

Or May be stalwar1‌ hic‌ helps you

[sagar_vij99 · Accepted solution]

Hi Anil, I found a solution and thought of sharing. I used three different variables and used them to calculate numbers using set and then did different aggregations to get the output. I hope thats correct and if you think there is any issue with it, please let me know.

[Anil_Babu_Samineni]

Glad you found the answer only thing you should share behind the correct answer so then next land up can tackle easily...