Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using the pivot table, in which I need to add an expression. In which, the num format of expression(One is percentage and other is decimal) and the label are written with conditional if. The if condition isn't working by default, the condition is applied only when the mentioned column is selected in the chart.
Please have a look at the expression in the attached qvf and kindly help.
Regrads,
Mohan
Hi,
what are you trying is impossible because of logical reasons. If can return only one value at time (true OR false). In scenario you want to use it is testing following condition.
Is Bus,Car,Train equal to Car? -> result NO -> else is returned.
And in addition to that you want single field to have two lables at same time, because field is used only once in pivot table (it is only question of visualization that you see it more times).
This will work only in case you will use such expression as field values
Hi Mohan,
i worked around , just check the app is it what ur required or it will help you furthur.
Thanks
PM
Hi Praveen,
Thanks for your time and checking this. I saw the attached qvf, the format which is shown cannot be used in the client required document. Since it'll mislead the users about the currency and brackets are used in finance to indicate the negative values.
Mohan
Hi,
what are you trying is impossible because of logical reasons. If can return only one value at time (true OR false). In scenario you want to use it is testing following condition.
Is Bus,Car,Train equal to Car? -> result NO -> else is returned.
And in addition to that you want single field to have two lables at same time, because field is used only once in pivot table (it is only question of visualization that you see it more times).
This will work only in case you will use such expression as field values
can this help mohan... if not i didnt properly understood your need ...what you want to see
Regards
PM
Hi Praveen,
Thanks for your time and providing the workaround. These are really useful.
Regards,
Mohan