Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement where, "One lab with one workshop, show the exact value. One lab with two workshop, show the minimum value. No lab or multi lab volume = 0"
I wrote the below logic and One lab with two workshop, show the minimum value logic is getting failed. Could someone help me with this issue. PFA the excel source file.
=if(GetSelectedCount ([LAB ID]) <> 1,0,
if(GetSelectedCount ([LAB ID]) = 1 and GetSelectedCount (Workshop) > 1,(aggr(([VOLUME/HOUR] * [EER/HOUR] * sum(Data)),[LAB ID],Workshop,MachineFamily_Name)),
([VOLUME/HOUR] * [EER/HOUR] * sum(Data))))
Thanks in Advance
Dev
Could you share your qvw with sample data where it shows how/what exactly you are trying to get?
Hi Tresesco,
I did few changes to the expression but still getting issues with "MY" region.
PFA the sample qvw.
Thanks
Nakul Dev
Thanks for sharing the app. Please help telling where should I look at (chart/text box). What would be the expected output ?
Hi Tresesco,
PFA the Filters image.
In filters apply one LAB ID and select both the WORKSHOPS the the VOLUME at the left bottom should show the minimum value instead combining both. Pls refer to the expression in QV(Vvolume variable) and excel attached earlier for reference
Min, which min? Could you tell me the right number for you for two selected workshops? And how do you calculate that? I am asking this because, I think there is a possibility of improvement in your expression.
In the image attached, the yellow highlighted are the values(min) need to be displayed.